title: Convert Numeric value to Varchar
body: <p>I'm trying to fetch the records and append some letters to my numeric column, but I'm getting an error. I tried with cast and convert function.</p>
  <p>For example:</p>
  <pre><code>select convert(varchar(10),StandardCost +'S')
  from DimProduct where ProductKey = 212
  </code></pre>
  <p>here <code>StandardCost</code> is a numeric field, but when I fetch the record I get an error.</p>