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