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

Update: Link doesn't seem to work from UT. Try Googling 'SQL Reference for SQL Server CE' and look at 'DataTypes' on the TechNew page.