SQL where field like ■

Question

I have a SQL database where some data has a ■ in it. When I run a like query for that it does't find anything? I need to correct it as it stops the data transforming to xml?

WHERE [value] like '%■%'?

Answer 1

Some time unicode does not work, so you can follow the below steps

1. Copy the field value and paste it Notepad
2. Copy that special character
3. Paste between the Like statement.

I am sure it will works. Please confirm.

Answer 2

WHERE [value] like N'%■%'?

Query it as unicode