>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
See if:
WHERE SearchMe $ UPPER(Item_desc)
is any faster
Chris McCandless
Red Sky Software