If he is sure that the right part is always 3 characters long then: trim(substring(postcode,1,length(postcode)-3));