>>>>>Does anyone have any experience with the date field that was added to SQL Server 2008?
>>>>
>>>>What is the question that requires experience? It is a date field (like date only version of datetime).
>>>>If you would ask:
>>>>-Why you get it back as a character value then I would say my guess would be that you are using and older version's driver.
>>>>-If it supports 'empty' no it doesn't, defaults to 1/1/1900.
>>>>-Its range, from Jan 1, 1 to Dec 31,9999.
>>>>-Accuracy, one day, storage 3bytes.
>>>>
>>>>Nothing else special about it I think.
>>>>Cetin
>>>
>>>Thanks for responding.
>>>When you say older driver are you refering to the ODBC driver?
>>
>>No not specifically ODBC but the ODBC or OLEDB for SQL2000, 2005. ie:
>>

handle = SQLSTRINGCONNECT('Driver={SQL Server Native Client 10.0};'+;
>>   'Server=.\sql2008;Database=myDb;Trusted_Connection=yes;')

>>works while
>>Driver={SQL Server Native Client}
>>Driver={SQL Server}
>>
>>do not. Older drivers have problems with new data types.
>>Cetin
>
>Thanks. I am looking into it.

Thanks again. I tried it. Worked great.