>Is there any way to find out what the data type of a field in SQL Server? I need to program against using DateTime and Small Date for comparisons.
>TIA!
>DLC

Dave,

From VFP use can use SQLColumns() with the NATIVE option. The call would look like this:

SQLColumns(hConnect, 'tablename', 'NATIVE')

SQLColumns() will return a result set that contains one row for each column in then table.

BTW, The VFP engine will convert both datetime and smalldatetime to VFP's datatime datatype.

-Mike