>Hi Tamar. Thanks for your reply.
>
>>YOu could use SYS(3054) to check all your queries.
>
>My problem is in trying to identify all places in my apps (There could be 500 forms and 100 prg) where I have used the following syntax:
> Select ..... where lcAnyVariable = MyFieldName
> instead of :
> Select ...... where MyFieldName = lcAnyVariable
>
>I have,nt used Sys(3054) but looking at the help it would appear that I first need to locate all the places in my app where I have a select statemnt and then insert this code.

If you're using VFP 9, you can combine SYS(3054) with SYS(3091) to send all the optimization results to a text file. Then you can examine the text file to find the queries that need attention and fix only those.

Tamar