This question would be best asked in a newsgroup specific about the T-SQL
language such as m.p.sqlserver.programming. Also, the official newsgroup
for ADP is m.p.access.adp.sqlserver.
As for your question, use the Convert or the Cast function:
select convert (datetime, 0)
Don't forget that there is a difference of two days between Access and
SQL-Server for an integer value: CDate (0) = '1899-12-30' in Access while
Convert(datetime, 0) will give you '1900-01-01'.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)