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 (probably because of optimization)... SELECT MIXED_COLUMN, MIXED_COLUMN + 0 FROM TABLE WHERE MIXED_COLUMN = MIXED_COLUMN + 0 ; Hey, lets make an IS_DECIMAL UDF! ;) ---- p.s. why aren't the addresses of these mailing lists anywhere to be found on the MySQL Lists pages? Dan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
