trim the last three, rather than selecting the first few (which is what I think you are trying to do)

in excel this would be something like:
=TRIM(LEFT(A1,LEN(A1)-3))

not sure about sql as not done it in about 4 years

__________________
WelshStew
Lead Administrator
tierney rides tboard - uk site | xtreme wales - extreme clothing
If you think I've helped, click the "Thanks"
webforumz - facebook | LinkedIn