WHERE Name LIKE N'[CDW]%';
What is the function of the 'N' after LIKE.
This is an old post, but it never had a reply because it's on a section that no one checks.
The N indicates that the string is a Unicode string.
Here's an example you can run to see the difference (copy and paste):
SELECT N'?', '?'
Luis C.How to post data/code on a forum to get the best help: Option 1 / Option 2
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?