Testing for NUMERIC values in an EVALUATE statement.

From: Ubiquitous (weberm...)

I am testing an alpha-numeric field with an EVALUATE statement to make sure
it is numeric.
Since I can't use "IS NUMERIC", I am using "'000' THRU '999'" in the WHEN
clause but I
wonder if there is a better way, since values like '0A1' will evalaute as
TRUE in that WHEN
clause?

Share |