in oracle sql it would be:

select Rtrim(substr(postcode, 0, LENGTH (postcode) -3 ) ) from address

it may be similar in mysql??

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