title: How to check if decimal is valid value in Teradata
body: <p>How to check if the given decimal is valid. I usually do a case statement like below to check if column is invalid or NULL then set it to 0 else take it as it is:</p>
  
  <pre><code>case when decimal_column is NULL or decimal_column NOT BETWEEN -999999999999 AND 999999999999 then 0 else decimal_column end
  </code></pre>
  
  <p>Can anyone please let me know if the above query looks correct</p>
  
  <p>Thanks</p>