extract a text

[CRISPAN]

i have a batch programm and I need to extract text from a 6 digit the last 2 digits and then use it to make a filter

for example, a field with a list of 6 digit numbers only filter that end with the number 50

[khurshid.arshad]

Dear Crispan;

use this link to extract text.

http://csprousers.org/forum/viewtopic.php?f=1&t=504

If this link is not working then see 20th topic on page 7 under "Entry" option.



a.

[Gregory Martin]

If the field is numeric your condition can be:

VAL % 100 = 50

If the field is alpha:

VAL[5:2] = "50"