number of errors=0
number of warnings=0
country=GB
Group=chkGrpPostalCode
select distinct trim(substr(zip,1,position(' ' in zip))) from zip_code where countrycode='GB' and length(zip)>5 and not trim(substr(zip,1,position(' ' in zip))) in (select zip from zip_code where countrycode='GB' and isreduced)
btrim