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]
>>How do I pass a date condition in the where clause of a Select statement using:-
Aman
-------
Lets fly away to the Land where there is Love & Peace