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