You can use regular expressions to validate 1* Select 1 from dual where regexp_like ('SomeString100and','[0-9]') SQL> / 1 ---------- 1 1* Select 1 from dual where regexp_like ('SomeString','[0-9]') SQL> / no rows selected Thanks Debaditya Chatterjee On Tue, Aug 18, 2009 at 2:19 PM, Michael Moore <michaeljmoore@xxxxxxxxx>wrote: > What is the best way to see if a string contains a valid number? 10gR2 > > thanks, > Mike >