How do you check if a field contains all numeric values using Teradata SQL?
<p>I'm looking for a function similar to <code>ISNUMERIC()</code> from T-SQL with Teradata SQL. I'd like a simple method to return a Boolean (or numeric 1/0) if the data contained in a character-type field is all numeric.</p>

<p>For example:</p>

<p>My column contains the following records: <code>'001'</code> and <code>'ABC'</code></p>

<p>I'd expect the query to return: <strong>1 (or True)</strong> and <strong>0 (or False)</strong>.</p>

<p>Is there a method similar to <code>ISNUMERIC()</code> natively supported by TD? I found a few options using regex that I could use, but wanted to see if there was a simpler method before going down that path. If such a method doesn't exist, I'm open to suggestions on accomplishing this.</p>