select *,rtrim(left(postcode,len(postcode)-3)) as smallpostcode from serviceproviders where len(postcode)>5 and ( rtrim(left(postcode,len(postcode)-3)) = 'GU1' or rtrim(left(postcode,len(postcode)-3)) = 'GU10' or rtrim(left(postcode,len(postcode)-3)) = 'GU11' or rtrim(left(postcode,len(postcode)-3)) = 'GU12' or rtrim(left(postcode,len(postcode)-3)) = 'GU13' or rtrim(left(postcode,len(postcode)-3)) = 'GU14' or rtrim(left(postcode,len(postcode)-3)) = 'GU15' or rtrim(left(postcode,len(postcode)-3)) = 'GU16' or rtrim(left(postcode,len(postcode)-3)) = 'GU17' or rtrim(left(postcode,len(postcode)-3)) = 'GU18' or rtrim(left(postcode,len(postcode)-3)) = 'GU19' or rtrim(left(postcode,len(postcode)-3)) = 'GU2' or rtrim(left(postcode,len(postcode)-3)) = 'GU20' or rtrim(left(postcode,len(postcode)-3)) = 'GU21' or rtrim(left(postcode,len(postcode)-3)) = 'GU22' or rtrim(left(postcode,len(postcode)-3)) = 'GU23' or rtrim(left(postcode,len(postcode)-3)) = 'GU24' or rtrim(left(postcode,len(postcode)-3)) = 'GU25' or rtrim(left(postcode,len(postcode)-3)) = 'GU26' or rtrim(left(postcode,len(postcode)-3)) = 'GU27' or rtrim(left(postcode,len(postcode)-3)) = 'GU3' or rtrim(left(postcode,len(postcode)-3)) = 'GU30' or rtrim(left(postcode,len(postcode)-3)) = 'GU32' or rtrim(left(postcode,len(postcode)-3)) = 'GU33' or rtrim(left(postcode,len(postcode)-3)) = 'GU34' or rtrim(left(postcode,len(postcode)-3)) = 'GU35' or rtrim(left(postcode,len(postcode)-3)) = 'GU4' or rtrim(left(postcode,len(postcode)-3)) = 'GU46' or rtrim(left(postcode,len(postcode)-3)) = 'GU47' or rtrim(left(postcode,len(postcode)-3)) = 'GU5' or rtrim(left(postcode,len(postcode)-3)) = 'GU51' or rtrim(left(postcode,len(postcode)-3)) = 'GU52' or rtrim(left(postcode,len(postcode)-3)) = 'GU6' or rtrim(left(postcode,len(postcode)-3)) = 'GU7' or rtrim(left(postcode,len(postcode)-3)) = 'GU8' or rtrim(left(postcode,len(postcode)-3)) = 'GU9' or rtrim(left(postcode,len(postcode)-3)) = 'HA0' or rtrim(left(postcode,len(postcode)-3)) = 'HA1' or rtrim(left(postcode,len(postcode)-3)) = 'HA2' or rtrim(left(postcode,len(postcode)-3)) = 'HA3' or rtrim(left(postcode,len(postcode)-3)) = 'HA4' or rtrim(left(postcode,len(postcode)-3)) = 'HA5' or rtrim(left(postcode,len(postcode)-3)) = 'HA6' or rtrim(left(postcode,len(postcode)-3)) = 'HA7' or rtrim(left(postcode,len(postcode)-3)) = 'HA9' or rtrim(left(postcode,len(postcode)-3)) = 'HP1' or rtrim(left(postcode,len(postcode)-3)) = 'HP10' or rtrim(left(postcode,len(postcode)-3)) = 'HP11' or rtrim(left(postcode,len(postcode)-3)) = 'HP12' or rtrim(left(postcode,len(postcode)-3)) = 'HP13' or rtrim(left(postcode,len(postcode)-3)) = 'HP14' or rtrim(left(postcode,len(postcode)-3)) = 'HP15' or rtrim(left(postcode,len(postcode)-3)) = 'HP16' or rtrim(left(postcode,len(postcode)-3)) = 'HP17' or rtrim(left(postcode,len(postcode)-3)) = 'HP18' or rtrim(left(postcode,len(postcode)-3)) = 'HP19' or rtrim(left(postcode,len(postcode)-3)) = 'HP2' or rtrim(left(postcode,len(postcode)-3)) = 'HP20' or rtrim(left(postcode,len(postcode)-3)) = 'HP21' or rtrim(left(postcode,len(postcode)-3)) = 'HP22' or rtrim(left(postcode,len(postcode)-3)) = 'HP23' or rtrim(left(postcode,len(postcode)-3)) = 'HP27' or rtrim(left(postcode,len(postcode)-3)) = 'HP3' or rtrim(left(postcode,len(postcode)-3)) = 'HP4' or rtrim(left(postcode,len(postcode)-3)) = 'HP5' or rtrim(left(postcode,len(postcode)-3)) = 'HP6' or rtrim(left(postcode,len(postcode)-3)) = 'HP7' or rtrim(left(postcode,len(postcode)-3)) = 'HP8' or rtrim(left(postcode,len(postcode)-3)) = 'HP9' or rtrim(left(postcode,len(postcode)-3)) = 'KT1' or rtrim(left(postcode,len(postcode)-3)) = 'KT10' or rtrim(left(postcode,len(postcode)-3)) = 'KT11' or rtrim(left(postcode,len(postcode)-3)) = 'KT12' or rtrim(left(postcode,len(postcode)-3)) = 'KT13' or rtrim(left(postcode,len(postcode)-3)) = 'KT14' or rtrim(left(postcode,len(postcode)-3)) = 'KT15' or rtrim(left(postcode,len(postcode)-3)) = 'KT16' or rtrim(left(postcode,len(postcode)-3)) = 'KT2' or rtrim(left(postcode,len(postcode)-3)) = 'KT21' or rtrim(left(postcode,len(postcode)-3)) = 'KT22' or rtrim(left(postcode,len(postcode)-3)) = 'KT23' or rtrim(left(postcode,len(postcode)-3)) = 'KT24' or rtrim(left(postcode,len(postcode)-3)) = 'KT5' or rtrim(left(postcode,len(postcode)-3)) = 'KT6' or rtrim(left(postcode,len(postcode)-3)) = 'KT7' or rtrim(left(postcode,len(postcode)-3)) = 'KT8' or rtrim(left(postcode,len(postcode)-3)) = 'KT9' or rtrim(left(postcode,len(postcode)-3)) = 'OX1' or rtrim(left(postcode,len(postcode)-3)) = 'OX10' or rtrim(left(postcode,len(postcode)-3)) = 'OX11' or rtrim(left(postcode,len(postcode)-3)) = 'OX12' or rtrim(left(postcode,len(postcode)-3)) = 'OX13' or rtrim(left(postcode,len(postcode)-3)) = 'OX14' or rtrim(left(postcode,len(postcode)-3)) = 'OX2' or rtrim(left(postcode,len(postcode)-3)) = 'OX29' or rtrim(left(postcode,len(postcode)-3)) = 'OX3' or rtrim(left(postcode,len(postcode)-3)) = 'OX33' or rtrim(left(postcode,len(postcode)-3)) = 'OX39' or rtrim(left(postcode,len(postcode)-3)) = 'OX4' or rtrim(left(postcode,len(postcode)-3)) = 'OX44' or rtrim(left(postcode,len(postcode)-3)) = 'OX49' or rtrim(left(postcode,len(postcode)-3)) = 'OX5' or rtrim(left(postcode,len(postcode)-3)) = 'OX9' or rtrim(left(postcode,len(postcode)-3)) = 'RG1' or rtrim(left(postcode,len(postcode)-3)) = 'RG10' or rtrim(left(postcode,len(postcode)-3)) = 'RG12' or rtrim(left(postcode,len(postcode)-3)) = 'RG14' or rtrim(left(postcode,len(postcode)-3)) = 'RG17' or rtrim(left(postcode,len(postcode)-3)) = 'RG18' or rtrim(left(postcode,len(postcode)-3)) = 'RG19' or rtrim(left(postcode,len(postcode)-3)) = 'RG2' or rtrim(left(postcode,len(postcode)-3)) = 'RG20' or rtrim(left(postcode,len(postcode)-3)) = 'RG21' or rtrim(left(postcode,len(postcode)-3)) = 'RG22' or rtrim(left(postcode,len(postcode)-3)) = 'RG23' or rtrim(left(postcode,len(postcode)-3)) = 'RG24' or rtrim(left(postcode,len(postcode)-3)) = 'RG25' or rtrim(left(postcode,len(postcode)-3)) = 'RG26' or rtrim(left(postcode,len(postcode)-3)) = 'RG27' or rtrim(left(postcode,len(postcode)-3)) = 'RG28' or rtrim(left(postcode,len(postcode)-3)) = 'RG29' or rtrim(left(postcode,len(postcode)-3)) = 'RG30' or rtrim(left(postcode,len(postcode)-3)) = 'RG31' or rtrim(left(postcode,len(postcode)-3)) = 'RG4' or rtrim(left(postcode,len(postcode)-3)) = 'RG40' or rtrim(left(postcode,len(postcode)-3)) = 'RG41' or rtrim(left(postcode,len(postcode)-3)) = 'RG42' or rtrim(left(postcode,len(postcode)-3)) = 'RG45' or rtrim(left(postcode,len(postcode)-3)) = 'RG5' or rtrim(left(postcode,len(postcode)-3)) = 'RG6' or rtrim(left(postcode,len(postcode)-3)) = 'RG7' or rtrim(left(postcode,len(postcode)-3)) = 'RG8' or rtrim(left(postcode,len(postcode)-3)) = 'RG9' or rtrim(left(postcode,len(postcode)-3)) = 'SL0' or rtrim(left(postcode,len(postcode)-3)) = 'SL1' or rtrim(left(postcode,len(postcode)-3)) = 'SL2' or rtrim(left(postcode,len(postcode)-3)) = 'SL3' or rtrim(left(postcode,len(postcode)-3)) = 'SL4' or rtrim(left(postcode,len(postcode)-3)) = 'SL5' or rtrim(left(postcode,len(postcode)-3)) = 'SL6' or rtrim(left(postcode,len(postcode)-3)) = 'SL7' or rtrim(left(postcode,len(postcode)-3)) = 'SL8' or rtrim(left(postcode,len(postcode)-3)) = 'SL9' or rtrim(left(postcode,len(postcode)-3)) = 'SN7' or rtrim(left(postcode,len(postcode)-3)) = 'SO21' or rtrim(left(postcode,len(postcode)-3)) = 'SO23' or rtrim(left(postcode,len(postcode)-3)) = 'SO24' or rtrim(left(postcode,len(postcode)-3)) = 'SP10' or rtrim(left(postcode,len(postcode)-3)) = 'SP11' or rtrim(left(postcode,len(postcode)-3)) = 'SW14' or rtrim(left(postcode,len(postcode)-3)) = 'TW1' or rtrim(left(postcode,len(postcode)-3)) = 'TW10' or rtrim(left(postcode,len(postcode)-3)) = 'TW11' or rtrim(left(postcode,len(postcode)-3)) = 'TW12' or rtrim(left(postcode,len(postcode)-3)) = 'TW13' or rtrim(left(postcode,len(postcode)-3)) = 'TW14' or rtrim(left(postcode,len(postcode)-3)) = 'TW15' or rtrim(left(postcode,len(postcode)-3)) = 'TW16' or rtrim(left(postcode,len(postcode)-3)) = 'TW17' or rtrim(left(postcode,len(postcode)-3)) = 'TW18' or rtrim(left(postcode,len(postcode)-3)) = 'TW19' or rtrim(left(postcode,len(postcode)-3)) = 'TW2' or rtrim(left(postcode,len(postcode)-3)) = 'TW20' or rtrim(left(postcode,len(postcode)-3)) = 'TW3' or rtrim(left(postcode,len(postcode)-3)) = 'TW4' or rtrim(left(postcode,len(postcode)-3)) = 'TW5' or rtrim(left(postcode,len(postcode)-3)) = 'TW6' or rtrim(left(postcode,len(postcode)-3)) = 'TW7' or rtrim(left(postcode,len(postcode)-3)) = 'TW8' or rtrim(left(postcode,len(postcode)-3)) = 'TW9' or rtrim(left(postcode,len(postcode)-3)) = 'UB1' or rtrim(left(postcode,len(postcode)-3)) = 'UB10' or rtrim(left(postcode,len(postcode)-3)) = 'UB11' or rtrim(left(postcode,len(postcode)-3)) = 'UB2' or rtrim(left(postcode,len(postcode)-3)) = 'UB3' or rtrim(left(postcode,len(postcode)-3)) = 'UB4' or rtrim(left(postcode,len(postcode)-3)) = 'UB5' or rtrim(left(postcode,len(postcode)-3)) = 'UB6' or rtrim(left(postcode,len(postcode)-3)) = 'UB7' or rtrim(left(postcode,len(postcode)-3)) = 'UB8' or rtrim(left(postcode,len(postcode)-3)) = 'UB9' or rtrim(left(postcode,len(postcode)-3)) = 'W13' or rtrim(left(postcode,len(postcode)-3)) = 'W3' or rtrim(left(postcode,len(postcode)-3)) = 'W4' or rtrim(left(postcode,len(postcode)-3)) = 'W5' or rtrim(left(postcode,len(postcode)-3)) = 'W7' or rtrim(left(postcode,len(postcode)-3)) = 'WD1' or rtrim(left(postcode,len(postcode)-3)) = 'WD17' or rtrim(left(postcode,len(postcode)-3)) = 'WD18' or rtrim(left(postcode,len(postcode)-3)) = 'WD19' or rtrim(left(postcode,len(postcode)-3)) = 'WD2' or rtrim(left(postcode,len(postcode)-3)) = 'WD23' or rtrim(left(postcode,len(postcode)-3)) = 'WD24' or rtrim(left(postcode,len(postcode)-3)) = 'WD25' or rtrim(left(postcode,len(postcode)-3)) = 'WD3' or rtrim(left(postcode,len(postcode)-3)) = 'WD4' or rtrim(left(postcode,len(postcode)-3)) = 'WD5' ) and webVisible = 1 AND wood = 1 AND stoveinstal = 0 AND fireplaceinstal = 0 AND doubleskinflue = 0 AND liner = 0 order by len(areas) asc
Harringtons FuelsDistance = 1 Miles
Click here for full details about Harringtons FuelsThames Valley FirewoodDistance = 2 Miles
Click here for full details about Thames Valley FirewoodGreen Fuel Technologies LimitedDistance = 6 Miles
Click here for full details about Green Fuel Technologies LimitedHome Farm LogsDistance = 6 Miles
Click here for full details about Home Farm LogsBPS PLUS LtdDistance = 6 Miles
Click here for full details about BPS PLUS LtdWILLIAMS CHIMNEY SERVICESDistance = 6 Miles
Click here for full details about WILLIAMS CHIMNEY SERVICESbradfield firewood suppliesDistance = 6 Miles
Click here for full details about bradfield firewood suppliesmackrory & sonsDistance = 6 Miles
Click here for full details about mackrory & sonsHotfirewood.comDistance = 6 Miles
Click here for full details about Hotfirewood.comA1 Logs HampshireDistance = 9 Miles
Click here for full details about A1 Logs HampshireCedardaleDistance = 10 Miles
Click here for full details about CedardaleLogboysDistance = 12 Miles
Click here for full details about LogboysJ H HUTT AND SONDistance = 12 Miles
Click here for full details about J H HUTT AND SONCPL Oxfordshire CoalDistance = 12 Miles
Click here for full details about CPL Oxfordshire CoalBraaiwood UKDistance = 13 Miles
Click here for full details about Braaiwood UKWoodcutters tree surgeons and forestryDistance = 13 Miles
Click here for full details about Woodcutters tree surgeons and forestrySimon Farndon Woodland & CountrysideDistance = 14 Miles
Click here for full details about Simon Farndon Woodland & Countrysidepiddington firewoodDistance = 14 Miles
Click here for full details about piddington firewoodR E North Firewood MerchantDistance = 14 Miles
Click here for full details about R E North Firewood MerchantLandmark Tree SurgeryDistance = 14 Miles
Click here for full details about Landmark Tree SurgeryBare woodDistance = 15 Miles
Click here for full details about Bare woodcsw log suppliesDistance = 15 Miles
Click here for full details about csw log suppliesArborline tree careDistance = 15 Miles
Click here for full details about Arborline tree careWhite Horse EnergyDistance = 15 Miles
Click here for full details about White Horse EnergyWoodland&CountrysideDistance = 17 Miles
Click here for full details about Woodland&CountrysideOxford Wood RecyclingDistance = 19 Miles
Click here for full details about Oxford Wood RecyclingC Daveies landscapes and tree careDistance = 20 Miles
Click here for full details about C Daveies landscapes and tree careLogs UnlimitedDistance = 21 Miles
Click here for full details about Logs UnlimitedHeated by WoodDistance = 21 Miles
Click here for full details about Heated by WoodRingrose Tree ServicesDistance = 22 Miles
Click here for full details about Ringrose Tree ServicesSeasoned Timber Copmany LtdDistance = 22 Miles
Click here for full details about Seasoned Timber Copmany LtdOxfordshire Stove Sweep CompanyDistance = 23 Miles
Click here for full details about Oxfordshire Stove Sweep CompanyD H NealDistance = 23 Miles
Click here for full details about D H NealD.s thomas garden servicesDistance = 23 Miles
Click here for full details about D.s thomas garden services4SGMDistance = 24 Miles
Click here for full details about 4SGMLC EnergyDistance = 26 Miles
Click here for full details about LC EnergyWinterfold Tree ServicesDistance = 26 Miles
Click here for full details about Winterfold Tree ServicesOlive Wood Direct.comDistance = 26 Miles
Click here for full details about Olive Wood Direct.comSeans Property ServicesDistance = 27 Miles
Click here for full details about Seans Property ServicesVerdo RenewablesDistance = 27 Miles
Click here for full details about Verdo RenewablesVerdo Renewables LtdDistance = 27 Miles
Click here for full details about Verdo Renewables LtdSurrey tree care ltdDistance = 28 Miles
Click here for full details about Surrey tree care ltdWessex Eco Fuels Ltd.Distance = 28 Miles
Click here for full details about Wessex Eco Fuels Ltd.FORD LANDSCAPING LTDDistance = 28 Miles
Click here for full details about FORD LANDSCAPING LTDCPL London CoalDistance = 29 Miles
Click here for full details about CPL London CoalThe Log StoreDistance = 30 Miles
Click here for full details about The Log Store
Click here to conduct another search
If you are a wood supplier and would like to appear here for free then please complete this simple Application form
We provide this as a an extra information service to our customers but obviously do not have time to go out and individually vet all the people listed. We cannot be held responsible if you are not satisfied with any of the people or companies listed here as you will be dealing with them directly. Please do let us know though is you have a particular complaint about someone listed.