How do you convert a Unicode Integer into a Unicode Character in SQL Server 2005.
For example, SELECT UNICODE('$') returns 36.
I am looking for a function that takes 36 and returns '$'.
+4
A:
NChar should convert back, takes a range of 0 through 65535
Select NChar(36)
Returns '$'
Andrew
2009-12-08 13:00:09
Good stuff Andrew
tzup
2009-12-08 13:02:35