>Hi,
>Let me answer your questions:-
>1. Can you show your select statement?
>
>the select statment as follows:-
>L.text = 'Limited'
>table name = item
>recount() = 50000 record's
>item_no,adesc = fields on the table item
>
>select item_no from item where L.text $ adesc into cursor tmpitem order by adesc
>
>2. Do you have an index on Description field?
>yes i have an index
>
>Thank's
$, AT, LIKE %Text% operators are no Rushmore optimizable. You would not be able to achieve speed query unless you would have an extra table with all words. This is true for VFP tables.
If it's not broken, fix it until it is.
My Blog