Hello,

Is there a good way to search a character field for
the occurance of a string?

Currently I am using the following but it is very slow.
I do have CDX indexes on both of the fields and tried
with the order set and with no order.

SearchMe = "TEST"
Select item_no, item_desc from datafile;
Where ATCC(SearchMe, upper(item_desc))<> 0;
order by item_no nowait into cursor Find

Thanks in Advance for your help.

Jeff