title: SQL - Converting char to exact length varchar
body: <p>I am trying to do something like this:</p>
  
  <pre><code>SELECT CAST(MYCHARCOL AS VARCHAR(LEN(MYCHARCOL))) 
  FROM MYTABLE
  </code></pre>
  
  <p>How do I convert a char column to <code>varchar</code> that is the exact length of the data inside that char column?</p>