title: Leading Zeros getting truncated using SUBSTRING
body: <p>One of the values in the column is<br>
  <code>089-002007</code>  </p>
  
  <p>I wish to extract all the numbers after '-'</p>
  
  <pre><code>SELECT SUBSTR(EMP_NO,5)
  FROM Table_Name  
  </code></pre>
  
  <p>However, I get the output as '2007', the leading zeros got truncated. I have multiple values where it starts with 0 after the '-'.    </p>
  
  <p>how can I fix this?</p>