The only thing you have to watch for is parameters scope. It could be a problem if you're using wrapper function/method for SQLEXEC().
>Thanks. SPT parameters seems easier to implement.
>
>>You have two choices:
>
>>1. Convert VFP date to a string or number that SQL Server recognizes as a date. See
http://msdn2.microsoft.com/en-us/library/ms180878.aspx for more info
>>2. Use SPT parameters.
>
>>ldDate = DATE()
>>lcSQL = [SELECT * FROM mytable WHERE dtcol = ?ldDate]
--sb--