title: DB2 Length function
body: <p>I am trying to run the below line in an DB2 database but I am receiving an error. The substring function appears to be working however I think the issue is with the Length function.</p>
  
  <pre><code>LEFT TRIM(SUBSTRING(MCRDFLWP_REASON.abc,SUBSTRING(MCRDFLWP_REASON.abc,':')+1,LENGTH(MCRDFLWP_REASON.abc))) as "REASON"
  </code></pre>
  
  <p>Thank you.</p>