ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.Using LIKE operator with arabic in SQL Server<p>Hi <a class="username" rel="satabeach"> satabeach</a>,</p> <p>Refer below sample query.</p> <p><span style="text-decoration: underline;"><strong>SQL</strong></span></p> <pre class="brush: sql">DECLARE @FilterDataInArabic AS TABLE(Name NVARCHAR(MAX)) INSERT INTO @FilterDataInArabic VALUES(N&#39;لا أتكلم العربية&#39;) INSERT INTO @FilterDataInArabic VALUES(N&#39;ل أتكلم العربية&#39;) SELECT * FROM @FilterDataInArabic WHERE Name LIKE N&#39;لا%&#39;</pre>, 06 Jun 2019 00:30:23 GMT