Select Part of the value from a query

[gradinumcp]

Hi there,

I have a column in the table(Collection) called Contact where the data is in the format Name Ext eg. John lennon 1601. I want to write a query that will display just the name and another query that will display just the Ext--that is the right 4 numbers.

Any clues what the 2 queries will be????

Thanks in advance

 

[r937]

why two queries when one will do?

select left(Contact,length(Contact)-4) as name
     , right(Contact,4) as ext
  from Collection

r937.com | rudy.ca