>>Thanks for quick response!
>>
>>This is for SQL Pass Through. We have a program that converts the FoxPro data to acceptable to SQL Server. The current code converts the date to a string which is fine for datetime but not small date. I will try out the SQLColumns function.
>>
>
>You should still be able to pass a datetime constant to SQL Server as a character value. SQL Server will do the implicit conversion. Are you getting an error because of the precision of the smalldatetime datatype.
>
>-Mike
No. According to the Transact-SQL Reference on page 189 there is a table of the data conversions. When comparing a DateTime to Char is implicit but comparing a smalldatetime to Char is explicit.
DLC