title: Is there a BigQuery version of isnumeric
body: <p>I need to test if a field is numeric or not using standard SQL in BigQuery. </p>
  
  <p>The example below works and is similar to what I have done in Cognos using TRANSLATE('mystring','1234567890.','') but its not very elegant.</p>
  
  <pre><code>SELECT
  IF(LENGTH(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE('1234.56','1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9',''),'0',''),'.',''))=0,
  'A number',
  'Not a number')
  </code></pre>