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
.
[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
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
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