Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Left or SubString

Status
Not open for further replies.
Jun 12, 2009
123
GB
Hi All,

I have a column (employee.ref) in my table (Employee) where the values are like

abc123456789

I am interested is bringing back 123456789 from this column

in my select statement, how do I do thats?

Many Thanks
 
If it always starts with 3 alphas then use substr

Substr(yourfield, 4,9)

Where I have used 9 replace with max length of nummeric string, if you want to return a number

to_number(Substr(yourfield, 4,9))

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top