Q:

Select string that contains square 2

I want to select rows that contain square 2 (this char '²')
I did select myColumn from table where myColumn '%²%' 
I got the columns that contain '²' but also the ones that contain '2'. 
I tried select myColumn from table where myColumn '%2%' and I got the same result. 
Is there a way in SQL Server to select the column that only contains the square 2 char? 

A:

You must use proper collation, like Latin1_General_BIN for example. 
declare @t table(t nvarchar(20))
insert into @t values('²'), ('2')
-- Will return only the row with the number. 
select * from @t where t like N'%2%' collate Latin1_General_BIN
-- Will return only the row with square 2. 
select * from @t where t like N'%²%' collate Latin1_General_BIN

