title: Variable only storing first letter of select result
body: <p>I have a cell that's has a two letter nvarchar as its content, which I want to  save to a simple nvarchar variable, however, only the first letter of the two-letter cell content is being saved with the following code. </p>
  
  <pre><code>DECLARE @RC NVARCHAR = (SELECT Value FROM @scoreTable WHERE Metric = 'RC')
  
  
  -- this returns 'ND' as expected
  SELECT Value FROM @scoreTable WHERE Metric = 'RC' 
  
  -- but this returns 'N'! Why?
  SELECT @RC 
  </code></pre>
  
  <p>I'm totally stumped. How can I get both letters (i.e. all of the content of the cell) to save to the variable <code>@RC</code>?</p>