Re: Find valid numeric values in a string field?

Eamon Daly - Original Message - From: Dan Bolser [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, April 10, 2005 10:10 AM Subject: Find valid numeric values in a string field? I have a column like this my_col varchar(20) null. The values in the column

Re: Find valid numeric values in a string field?

, 2005 10:10 AM Subject: Find valid numeric values in a string field? I have a column like this my_col varchar(20) null. The values in the column can be text or numbers. How can I select only those rows where the value in this column is a valid number? I need something like IS_DECIMAL(), but I

Find valid numeric values in a string field?

I have a column like this my_col varchar(20) null. The values in the column can be text or numbers. How can I select only those rows where the value in this column is a valid number? I need something like IS_DECIMAL(), but I can't find that function. The following SQL fails to do the job