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