>Hi Naomi,
>
>Thanks for the code. However, after following your recommendation, I still don't get anything. After my SELECT-SQL string, I have the SQLGETPROP, SQLSETPROP, SQLEXEC and SQLSETPROP again to query data in our Max Database.
>
>Do I also need to SET NEAR ON before my SELECT string? Please help.
>
>Thanks,
>Sam
SET NEAR has nothing to do with the SELECT-SQL. Your select will only work inside VFP and it should return all records where "1001" is in PartNum somewhere. The way it's written it is not Rushmore optimizable. If you want to search for PartNum starting with your number, use LIKE Value%
If you're using SQLEXEC, you may want to construct the whole query as a string.
If it's not broken, fix it until it is.
My Blog