change double-byte character to unicode in select

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 2000 Forums

Transact-SQL (2000)

change double-byte character to unicode in select

Author

Topic

yipchunyu
Yak Posting Veteran

80 Posts

Posted - 2004-02-10 : 02:14:02

Hi guys,
Some data stored in a table with double bytes characters.
However, i want to change it to unicode code in using the select statement. I tried cast, convert, N but it does seem to work for me. any advice?
appreciate any help.
thx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources