title: casting varchar to numeric in case of null
body: <p>How do I handle this conversion if the value is null, so that it does not give the error "Error converting data type varchar to numeric".</p>
  
  <pre><code>convert(numeric(19,2), mdmaster.check_no)as checkNbr,
  </code></pre>
  
  <p>Thanx </p>