ISNUMERIC Function?
The ISNUMERIC function written above is not entirely accurate. It will identify non-numeric strings as numeric and numeric strings as non-numeric. Example: '....'. This is not a numeric string and will not be recognized as such by Vertica (ie CAST ('....' as DOUBLE PRECISION)). However the regular expression will match this.