>>>>>>>>>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
__

No, the compact edition does not have a date type as far as I can see