>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
>
ATCC() is not Rushmore optimizable, and an index is basically useless to improve the speed - the AT() family, LIKE(), OCCURS(), substring search (the $ operator or a LIKE clause in a SELECT) or something like VBScript.RegExp, so there's no way to resolve this without examining each potential record's field one record at a time.