>>you can also write the WHERE clause:
>>
>>... where FieldName like '%&MyVar.%'
>>
>>This will return rows where your variable text string is anywhere in the field, not just at the beginning of the field.
>
>
>Mark,
>
>Excuse me for butting in but, will "where FieldName like '%&MyVar.%'" run faster than
>"where ATC(myvar, mytable.myfield) > 0"? I am also trying to find a fast way of searching
>for strings inside of a character field.
>
>Thanks
>Jerry Tovar
ATC will work but performance suffers because the ATC function will be evaluated for each row in the table. like '%MyVar.%' runs more efficiently.
Mark McCasland
Midlothian, TX USA