>>>Which version do you have ?
>>Sorry. I assumed you meant DateTime. No version of MS SQL has a 'Date' datatype.
>
>SQL Server 2008 has Date datatype.

So it does! I didn't know that. So (going back a few posts) I guess you're now happy viz-a-viz the CE compact edition and the Date datatype :-}