Left or SubString

[informer30]

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

 

[IanWaterman]

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

 

[informer30]

That's brill....cheers Ian