Query Help – Removing Characters Before A Hyphen

[aaaa]

got a table that needs some data removing, the data is like this:

column

aaa – bcv

dsa – asf

hfh – ank

vxc – afs

yny – agf

etc.

what I want it to return is the values after the hyphen, so something like this:

bcv

asf

ank

afs

agf

i know i could do a nested replace on this, but there are hundreds of these and new ones are regularly added so that would make it very difficult to manage if I did things that way, so I was wondering if anyone could help me on this? I'm thinking an equivalent of in excel using the find and replace, sort of like find: '* – '; replace ''.

thanks

[Author]

Posts