Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  Casting in Sql server CE

Author  Topic  Hach Starting Member 2 Posts Posted - 2007-02-06 : 09:02:17 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