Hi,
I would like to know if casting is supported in SQL Server Compact Edition. I get an error when i attempt to cast a datetime or bigint value to nvarchar or ntext. CAST(datetime AS nvarchar(15))
Does anybody knows if its supported or how could i cast values
Thank you

SQL CE casting
RHPT
The T-SQL CONVERT function is supported by SQL 2005 Compact Edition, CAST is not available.
For example: CONVERT(nvarchar(10), OrderDate, 101)