T-SQL - Checking for Unicode characters
Here is a code in T-SQL which will check if a string contains UNICODE characters:
Lets create a table variable:
declare @temp table (Name varchar(100), Address1 nvarchar(200))
Now we will insert two records, one of which contains ascii and one non-ascii character.