RE: Case statement on nvarchar with literal string comparrison to varchar

SSC Guru

Points: 398711

April 14, 2015 at 4:29 am

You can force the literal string to be NVARCHAR by using the N'Somestring' syntax. Try that with the same code.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt