Re: IsNumeric() clause in MySQL??
That almost works, but in that vein, it has to be:
where COL1 = concat( '', 0 + COL1 )
because in mysql ( 123 = '123anything' ) evaluates to true.
But note that this method does not work for numbers that begin with 0.
Subject
Written By
Posted
September 10, 2004 12:08PM
September 16, 2004 10:31PM
February 02, 2005 01:37PM
Re: IsNumeric() clause in MySQL??
January 29, 2006 11:24PM
November 24, 2008 04:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.