hi

Iam using sql server 2008 r2 with database that saving Arabic and English with it, when i use this sql statement

SELECT * FROM Land_Files WHERE Briefness LIKE '%Qusin%'

it gives me aresult but when i use the same sql Statment with small difference :

SELECT * FROM Land_Files WHERE Briefness LIKE '%قوصين%'

it does not give any result but I am sure i have the word قوصين in Briefness column.

what is the wrong with searching with arabic??

how can i solve this problem ?

Best Thanks