'LIKE' keyword is not working in sql server 2008

sql-like, sql-server, sql-server-2008

Solution

Plese use N before string if language is not a english:

  SELECT * from Ayyat where Data like N'%انسان%' ;

Problem

I have bulk-data in SQL-Server table. One of the fields contains following data : ``` '(اے انسان!) کیا تو نہیں جانتا)' ``` Tried: ``` SELECT * from Ayyat where Data like '%انسان%' ; ``` but it is showing no-result.

Original source