title: Argument data type numeric is invalid for argument 1 of substring function
body: <p>I get the following message with this code </p>
  
  <pre><code>case when substring(New_Limit,11,1)=' ' then '0'+substring(New_Limit,1,10)
  </code></pre>
  
  <p>The 'then' bit is meant to concat the 0 and substring.
  Any help?</p>