Anuj,
there's a few ways to do this, here's one way

select * from voucher_master where replace(translate(voucher_no,'0123456789','**********'),'*') is null;

- ant

-----Original Message-----
From: Anuj Kumar Sharma [mailto:oracledba-ezmlmshield-x10533696.[Email address protected]
Sent: Friday, July 16, 2004 5:37 AM
To: LazyDBA Discussion
Subject: To Number Problem


hi ,
i wanto to select only number like
1,2,3, no a12 , 4859,SI
 
voucher_master
===============
voucher_no varchar2(25)


voucher_master
--------------
1
2
3
a12
b324
4859,SI
2838,SB




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page