title: Put N Unicode before variable in SQL Server?
body: <p>We usually use <code>N</code> for unicode string literals like this:</p>
  
  <pre><code>Select * 
  From Customer 
  Where Name = N'កខគ' --Unicode
  </code></pre>
  
  <p>Now I want to change it to be like this:</p>
  
  <pre><code>Declare @a varchar(Max)
  
  Select * 
  From Customer 
  Where Name = N''+@a
  </code></pre>
  
  <p>At the second SQL statement it doesn't work at all. Any ideas? Thank you in advance.</p>