when I search about some arabic words in sql server , it doesn't distinguish between 'ة' and 'ت' and it shows them all
like in this picture
Try to collate
them as
where emp_firstname collate Arabic_BIN = N'نعمت'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With