Hi All,
I'm trying to get the right hand part of a text string so i am only left with the depot name.
Here's how i get them...
49 - Manchester
51/CVT - Nuneaton
58/TEJ - Teeside
8 - Park Royal
Here's what i'd like...
Manchester
Nuneaton
Teeside
Park Royal
Can anyone help with a statement in a query that'll acheive this??
Ta, spin.
I'm trying to get the right hand part of a text string so i am only left with the depot name.
Here's how i get them...
49 - Manchester
51/CVT - Nuneaton
58/TEJ - Teeside
8 - Park Royal
Here's what i'd like...
Manchester
Nuneaton
Teeside
Park Royal
Can anyone help with a statement in a query that'll acheive this??
Ta, spin.