Hi!
>However if you specify only date portion for datetime field SQL Server will add 00:00:00 as a time when it converts it to datetime.
That's exactly what I meant as "empty time" :-)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.