� IN SQL Server database

Question

in my database I have this char �. I want to locate them with a query

Select * 
from Sometable 
where somecolumn like '%�%'

this gets me no result.

I think it is ANSI encoding

Answer 1

use N like below

 where col like N'%�%'

why do you think ,you need N prefix:

Prefix Unicode character string constants with the letter N. Without the N prefix, the string is converted to the default code page of the database. This default code page may not recognize certain characters.

Thanks to Martin Smith,Earlier i tested only with one character earlier and it worked,but as Martin pointed out, it returns all characters..

Below query works and returns only intended

select * from #demo where id  like N'%�%' 
COLLATE Latin1_General_100_BIN

Demo:

create table #demo
(
id nvarchar(max)
)

insert into #demo
values
(N'ﬗ'),
( N'�')

to know more about unicode,please see below links

http://kunststube.net/encoding/

https://www.joelonsoftware.com/2003/10/08/the-absolute-minimum-every-software-developer-absolutely-positively-must-know-about-unicode-and-character-sets-no-excuses/