>>>>>>>>Hi,
>>>>>>>>Did you consider the CE edition. That will run with embedded .NET DLLs only - but it's not multi-user.......
>>>>>>>__
>>>>>>>
>>>>>>>Viv,
>>>>>>>
>>>>>>>I'll have a look at it - no Date type though
>>>>>>
>>>>>>Sure there is
>>>>>__
>>>>>
>>>>>You're sure you're not talking about sql server 2008 ?
>>>>>
>>>>>

>>>>>&& bol Compact 3.5 sp1
>>>>>
>>>>>date
>>>>> nchar(10) value of the form 'YYYY-MM-DD'
>>>>>
>>>>>Note:
>>>>>SQL Server Compact stores wide characters. Conversion support for this type was provided by the SQL Server Compact 3.5 SP1 release.
>>>>>

>>>>
>>>>Already there in the 2000 edition:
>>>>http://technet.microsoft.com/en-us/library/aa237918(SQL.80).aspx
>>>__
>>>
>>>DateTime type, yes. Date type, no
>>>
>>>I've got the compact 3.5 sp1 installed on my system. When I add a field to a table, there's no 'date' type
>>>
>>>Which version do you have ?
>>Sorry. I assumed you meant DateTime. No version of MS SQL has a 'Date' datatype.
>______________
>
>Sql server 2008 has a Date type http://technet.microsoft.com/en-us/library/bb630352.aspx

So it does. Naomi pointed it out and I, not concentrated, replies to her thinking it was you.
IAC, at the end of the day, you have what you need - a Date datatype in SQL CE ?
Regards,
Viv