>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