Viewing 3 posts - 1 through 4 (of 4 total)
That worked, the collate seems to make everything behave as expected. But I'm with you, it would be nice if someone could explain it.
February 19, 2014 at 1:43 pm
#1690446
I tried out your script and it work great, thanks. And yes, it is a NCHAR(65533) that it shows at the end of our data.
February 18, 2014 at 4:37 pm
#1690098
I've tried the REPLACE but I can't seem to get it to work. I have tried REPLACE(POSTCODE,N'<diamond ?>','') and REPLACE(POSTCODE,NCHAR(65533),'') and neither of those seem to work. Is there a...
February 18, 2014 at 2:04 pm
#1690046