>>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
None of them are Rushmore optimizable... You can also try like operator or like function. I believe, though, your solution would be the fastest, Chris.
If it's not broken, fix it until it is.
My Blog