title: How to add N (unicode) to a variable (the value already in the variable)
body: <p>Well, I know there are some similar questions in the forum, but still there is no explicit solution.</p>
  
  <p>I want to add <code>N</code> to a variable to store double byte(Japanese) into db table, but I do not know how to add the <code>N</code> to a variable.</p>
  
  <p>The value is already in the variable <code>@value</code>, which it gets its value(Japanese) automatically from a CSV file.</p>
  
  <p>What I want to do is insert the value into a db table with correct Japanese chars. So I did </p>
  
  <pre><code>   declare @finalValue nvarchar(255);
     set @finalValue=N@value; --obviously, it is NOT correct.
     --insert ........
  </code></pre>
  
  <p>what should I do for inserting correct <code>@finalValue</code> into table?</p>