| How to know the String has numbers......... [message #4478] |
Fri, 13 December 2002 05:50  |
BABU SRSB
Messages: 42
Registered: June 2002
|
Member |
|
|
Hi all,
please suggest me on the below query.
table structure is
desc tb1
--------------
id varchar(10)
my data is
id
-------
0299
9834
H390
89U0
Y8I7
4420
i need the query of the below results
result one: the id has only numbers
id:
-----
0299
9834
4420
result two: the id has atleast alphanumeric
id:
-----
H390
89U0
Y8I7
Please suggest me about the query.
immediate response is appreciatable.
Regards,
Babu.
|
|
|
|
| Re: How to know the String has numbers......... [message #4480 is a reply to message #4478] |
Fri, 13 December 2002 06:52  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
use a Is_number function?
there are many versions of this kind of function(which is not a built-in).
our other posting gives out one such function.
change it according to your need.
idea is to use TO_NUMBER to check whether the given string is a number or not.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
