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