Tuesday, July 30, 2013

How to search using Like for special Character when Database collation is not suitable

declare @nstring nvarchar(20)=null
SET @nstring = N'كرم';select * from Customers where Customer_NameA like '%'+@nstring +'%'





reference:
http://msdn.microsoft.com/en-us/library/ms180059.aspx

No comments:

Post a Comment