title: Select Query giving output as ??????????? with different language text
body: <p>Why is this query giving me ???????? as output.</p>
  
  <pre><code> Declare     @Search    NVARCHAR(MAX) = 'اختبار كتاب اللغة العربية'
   SET @Search = N''+ @Search
   select   @Search
  </code></pre>
  
  <p>Where as  this one works fine :-</p>
  
  <pre><code> Declare     @Search    NVARCHAR(MAX) = N'اختبار كتاب اللغة العربية'
   select   @Search 
  </code></pre>
  
  <p>I want to make my query dynamic. Is there any other way I can do it?</p>
  
  <p>Dynamic in the sence I can pass anything in the @Search parameter. I have a .NET application where I will pass the string to be searched in the @Search parameter which can be either English or Arabic.</p>