AFAIK it should not make a difference, but you may test direct query just in case.


>I didn't believe there was anything else in the statement that was pertinent to the question that I didn't already post, but then I remembered this does use macro substitution. I'll have to test to see if that makes a difference.
>
>

>WhereClause = "right(PrSSNum,4) = '1234'"
>select PrEmpl, PrFirst, PrLast, PrSSNum, PrDept, PrDOH;
>   from PrEmpl;
>   where &WhereClause;
>   into cursor SearchTempCursor readwrite
>

>
>I had indicated my version (VFP 9 SP 1), but I did a preview of the post. If you do that and then submit it, it loses the settings for version, database, etc. Kind of an irritating problem that I mentioned to Michel, but one that he said would be fixed when they moved completely to ASPX for the site and would not fix in the current version.
>
>