Check for all numeric in a column

2003-01-31 Thread Smith, Ron L.
Title: Message What is the easiest / best way to check for a valid numeric value in a column? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you

RE: Check for all numeric in a column

2003-01-31 Thread Koivu, Lisa
. [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:25 AMTo: Multiple recipients of list ORACLE-LSubject: Check for all numeric in a column What is the easiest / best way to check for a valid numeric value in a column? R. Smith If you

RE: Check for all numeric in a column

2003-01-31 Thread Jamadagni, Rajendra
Title: RE: Check for all numeric in a column select * from your_table where replace(translate(your_column_name,'.1234567890','***'),'*') is not null / Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com

Re: Check for all numeric in a column

2003-01-31 Thread Jared . Still
by: [EMAIL PROTECTED] 01/31/2003 08:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Check for all numeric in a column What is the easiest / best way to check for a valid numeric value in a column? R