SQL Server: Check Unicode Characters in a column

I needed to check Unicode characters under a column in SQL Server. I could check using the below script
SELECT *
FROM ITEM
WHERE cast(cast([DESC] as varchar(max)) as nvarchar(max)) <> [DESC]

No comments:

Post a Comment