Re: IsNumeric() clause in MySQL??

[Cai Black]

Since the REGEXP function is aware of character class (and the you would not be using the back-references creating by the parens in the regexp), the following is a bit simpler and more straight-forward, IMHO:


CREATE FUNCTION ISNUMERIC (myVal VARCHAR(1024))
RETURNS TINYINT(1) DETERMINISTIC
RETURN myVal REGEXP '^[\-\+]?[[:digit:]]*\.?[[:digit:]]*$';