retrive a String Field from a particular position

redrose

Dear all,

I have one problem. I need to retrive a String Field,in which i need to apply a filter.

e.g My Field is having a data '61011701117'.and I have many records having similar data.

e.g '62011701117'.

'63011701117'.

'64011701118'. etc

I need to Retrive the records having the value '117' from the position 4 to 6 .How can i do it?

Is there any way by which i can apply SETFILTER for the same purpose? please explain?



Regards

Rose

kriki

Try this:

TheTable.SETFILTER("The Field",'???117*');

The ? means that there must be EXACT 1 character.