>Thank you. So I will need to convert from DateTime type to a data and then to string. Should not be a problem.
>
>>SQL Server does not understand VFP datetime literals
>>
>>TableName.FieldName >= '2010-04-01' and TableName.FieldName < '2010-05-02'
>>
>>>
No! Don't do that. Use parameters as I showed.
Cetin