select *,rtrim(left(postcode,len(postcode)-3)) as smallpostcode from serviceproviders where len(postcode)>5 and ( rtrim(left(postcode,len(postcode)-3)) = 'BB1' or rtrim(left(postcode,len(postcode)-3)) = 'BB10' or rtrim(left(postcode,len(postcode)-3)) = 'BB11' or rtrim(left(postcode,len(postcode)-3)) = 'BB12' or rtrim(left(postcode,len(postcode)-3)) = 'BB18' or rtrim(left(postcode,len(postcode)-3)) = 'BB2' or rtrim(left(postcode,len(postcode)-3)) = 'BB3' or rtrim(left(postcode,len(postcode)-3)) = 'BB4' or rtrim(left(postcode,len(postcode)-3)) = 'BB5' or rtrim(left(postcode,len(postcode)-3)) = 'BB6' or rtrim(left(postcode,len(postcode)-3)) = 'BB7' or rtrim(left(postcode,len(postcode)-3)) = 'BB8' or rtrim(left(postcode,len(postcode)-3)) = 'BB9' or rtrim(left(postcode,len(postcode)-3)) = 'BD1' or rtrim(left(postcode,len(postcode)-3)) = 'BD10' or rtrim(left(postcode,len(postcode)-3)) = 'BD12' or rtrim(left(postcode,len(postcode)-3)) = 'BD13' or rtrim(left(postcode,len(postcode)-3)) = 'BD14' or rtrim(left(postcode,len(postcode)-3)) = 'BD15' or rtrim(left(postcode,len(postcode)-3)) = 'BD16' or rtrim(left(postcode,len(postcode)-3)) = 'BD17' or rtrim(left(postcode,len(postcode)-3)) = 'BD18' or rtrim(left(postcode,len(postcode)-3)) = 'BD19' or rtrim(left(postcode,len(postcode)-3)) = 'BD2' or rtrim(left(postcode,len(postcode)-3)) = 'BD20' or rtrim(left(postcode,len(postcode)-3)) = 'BD21' or rtrim(left(postcode,len(postcode)-3)) = 'BD22' or rtrim(left(postcode,len(postcode)-3)) = 'BD23' or rtrim(left(postcode,len(postcode)-3)) = 'BD24' or rtrim(left(postcode,len(postcode)-3)) = 'BD3' or rtrim(left(postcode,len(postcode)-3)) = 'BD4' or rtrim(left(postcode,len(postcode)-3)) = 'BD5' or rtrim(left(postcode,len(postcode)-3)) = 'BD6' or rtrim(left(postcode,len(postcode)-3)) = 'BD7' or rtrim(left(postcode,len(postcode)-3)) = 'BD8' or rtrim(left(postcode,len(postcode)-3)) = 'BD9' or rtrim(left(postcode,len(postcode)-3)) = 'BL0' or rtrim(left(postcode,len(postcode)-3)) = 'BL1' or rtrim(left(postcode,len(postcode)-3)) = 'BL2' or rtrim(left(postcode,len(postcode)-3)) = 'BL3' or rtrim(left(postcode,len(postcode)-3)) = 'BL4' or rtrim(left(postcode,len(postcode)-3)) = 'BL5' or rtrim(left(postcode,len(postcode)-3)) = 'BL6' or rtrim(left(postcode,len(postcode)-3)) = 'BL7' or rtrim(left(postcode,len(postcode)-3)) = 'BL8' or rtrim(left(postcode,len(postcode)-3)) = 'BL9' or rtrim(left(postcode,len(postcode)-3)) = 'BT38' or rtrim(left(postcode,len(postcode)-3)) = 'BT40' or rtrim(left(postcode,len(postcode)-3)) = 'FY1' or rtrim(left(postcode,len(postcode)-3)) = 'FY2' or rtrim(left(postcode,len(postcode)-3)) = 'FY3' or rtrim(left(postcode,len(postcode)-3)) = 'FY4' or rtrim(left(postcode,len(postcode)-3)) = 'FY5' or rtrim(left(postcode,len(postcode)-3)) = 'FY6' or rtrim(left(postcode,len(postcode)-3)) = 'FY7' or rtrim(left(postcode,len(postcode)-3)) = 'FY8' or rtrim(left(postcode,len(postcode)-3)) = 'HD1' or rtrim(left(postcode,len(postcode)-3)) = 'HD2' or rtrim(left(postcode,len(postcode)-3)) = 'HD3' or rtrim(left(postcode,len(postcode)-3)) = 'HD4' or rtrim(left(postcode,len(postcode)-3)) = 'HD5' or rtrim(left(postcode,len(postcode)-3)) = 'HD6' or rtrim(left(postcode,len(postcode)-3)) = 'HD7' or rtrim(left(postcode,len(postcode)-3)) = 'HD9' or rtrim(left(postcode,len(postcode)-3)) = 'HX1' or rtrim(left(postcode,len(postcode)-3)) = 'HX2' or rtrim(left(postcode,len(postcode)-3)) = 'HX3' or rtrim(left(postcode,len(postcode)-3)) = 'HX4' or rtrim(left(postcode,len(postcode)-3)) = 'HX5' or rtrim(left(postcode,len(postcode)-3)) = 'HX6' or rtrim(left(postcode,len(postcode)-3)) = 'HX7' or rtrim(left(postcode,len(postcode)-3)) = 'L10' or rtrim(left(postcode,len(postcode)-3)) = 'L11' or rtrim(left(postcode,len(postcode)-3)) = 'L12' or rtrim(left(postcode,len(postcode)-3)) = 'L13' or rtrim(left(postcode,len(postcode)-3)) = 'L14' or rtrim(left(postcode,len(postcode)-3)) = 'L16' or rtrim(left(postcode,len(postcode)-3)) = 'L20' or rtrim(left(postcode,len(postcode)-3)) = 'L21' or rtrim(left(postcode,len(postcode)-3)) = 'L22' or rtrim(left(postcode,len(postcode)-3)) = 'L23' or rtrim(left(postcode,len(postcode)-3)) = 'L25' or rtrim(left(postcode,len(postcode)-3)) = 'L27' or rtrim(left(postcode,len(postcode)-3)) = 'L28' or rtrim(left(postcode,len(postcode)-3)) = 'L29' or rtrim(left(postcode,len(postcode)-3)) = 'L30' or rtrim(left(postcode,len(postcode)-3)) = 'L31' or rtrim(left(postcode,len(postcode)-3)) = 'L32' or rtrim(left(postcode,len(postcode)-3)) = 'L33' or rtrim(left(postcode,len(postcode)-3)) = 'L34' or rtrim(left(postcode,len(postcode)-3)) = 'L35' or rtrim(left(postcode,len(postcode)-3)) = 'L36' or rtrim(left(postcode,len(postcode)-3)) = 'L37' or rtrim(left(postcode,len(postcode)-3)) = 'L38' or rtrim(left(postcode,len(postcode)-3)) = 'L39' or rtrim(left(postcode,len(postcode)-3)) = 'L4' or rtrim(left(postcode,len(postcode)-3)) = 'L40' or rtrim(left(postcode,len(postcode)-3)) = 'L6' or rtrim(left(postcode,len(postcode)-3)) = 'L9' or rtrim(left(postcode,len(postcode)-3)) = 'LA1' or rtrim(left(postcode,len(postcode)-3)) = 'LA2' or rtrim(left(postcode,len(postcode)-3)) = 'LA3' or rtrim(left(postcode,len(postcode)-3)) = 'LA4' or rtrim(left(postcode,len(postcode)-3)) = 'LA5' or rtrim(left(postcode,len(postcode)-3)) = 'LA6' or rtrim(left(postcode,len(postcode)-3)) = 'LS29' or rtrim(left(postcode,len(postcode)-3)) = 'M1' or rtrim(left(postcode,len(postcode)-3)) = 'M11' or rtrim(left(postcode,len(postcode)-3)) = 'M12' or rtrim(left(postcode,len(postcode)-3)) = 'M13' or rtrim(left(postcode,len(postcode)-3)) = 'M14' or rtrim(left(postcode,len(postcode)-3)) = 'M15' or rtrim(left(postcode,len(postcode)-3)) = 'M16' or rtrim(left(postcode,len(postcode)-3)) = 'M17' or rtrim(left(postcode,len(postcode)-3)) = 'M18' or rtrim(left(postcode,len(postcode)-3)) = 'M19' or rtrim(left(postcode,len(postcode)-3)) = 'M2' or rtrim(left(postcode,len(postcode)-3)) = 'M20' or rtrim(left(postcode,len(postcode)-3)) = 'M21' or rtrim(left(postcode,len(postcode)-3)) = 'M22' or rtrim(left(postcode,len(postcode)-3)) = 'M23' or rtrim(left(postcode,len(postcode)-3)) = 'M24' or rtrim(left(postcode,len(postcode)-3)) = 'M25' or rtrim(left(postcode,len(postcode)-3)) = 'M26' or rtrim(left(postcode,len(postcode)-3)) = 'M27' or rtrim(left(postcode,len(postcode)-3)) = 'M28' or rtrim(left(postcode,len(postcode)-3)) = 'M29' or rtrim(left(postcode,len(postcode)-3)) = 'M3' or rtrim(left(postcode,len(postcode)-3)) = 'M30' or rtrim(left(postcode,len(postcode)-3)) = 'M31' or rtrim(left(postcode,len(postcode)-3)) = 'M32' or rtrim(left(postcode,len(postcode)-3)) = 'M33' or rtrim(left(postcode,len(postcode)-3)) = 'M34' or rtrim(left(postcode,len(postcode)-3)) = 'M35' or rtrim(left(postcode,len(postcode)-3)) = 'M38' or rtrim(left(postcode,len(postcode)-3)) = 'M4' or rtrim(left(postcode,len(postcode)-3)) = 'M40' or rtrim(left(postcode,len(postcode)-3)) = 'M41' or rtrim(left(postcode,len(postcode)-3)) = 'M43' or rtrim(left(postcode,len(postcode)-3)) = 'M44' or rtrim(left(postcode,len(postcode)-3)) = 'M45' or rtrim(left(postcode,len(postcode)-3)) = 'M46' or rtrim(left(postcode,len(postcode)-3)) = 'M5' or rtrim(left(postcode,len(postcode)-3)) = 'M6' or rtrim(left(postcode,len(postcode)-3)) = 'M60' or rtrim(left(postcode,len(postcode)-3)) = 'M7' or rtrim(left(postcode,len(postcode)-3)) = 'M8' or rtrim(left(postcode,len(postcode)-3)) = 'M9' or rtrim(left(postcode,len(postcode)-3)) = 'M90' or rtrim(left(postcode,len(postcode)-3)) = 'OL1' or rtrim(left(postcode,len(postcode)-3)) = 'OL10' or rtrim(left(postcode,len(postcode)-3)) = 'OL11' or rtrim(left(postcode,len(postcode)-3)) = 'OL12' or rtrim(left(postcode,len(postcode)-3)) = 'OL13' or rtrim(left(postcode,len(postcode)-3)) = 'OL14' or rtrim(left(postcode,len(postcode)-3)) = 'OL15' or rtrim(left(postcode,len(postcode)-3)) = 'OL16' or rtrim(left(postcode,len(postcode)-3)) = 'OL2' or rtrim(left(postcode,len(postcode)-3)) = 'OL3' or rtrim(left(postcode,len(postcode)-3)) = 'OL4' or rtrim(left(postcode,len(postcode)-3)) = 'OL5' or rtrim(left(postcode,len(postcode)-3)) = 'OL6' or rtrim(left(postcode,len(postcode)-3)) = 'OL7' or rtrim(left(postcode,len(postcode)-3)) = 'OL8' or rtrim(left(postcode,len(postcode)-3)) = 'OL9' or rtrim(left(postcode,len(postcode)-3)) = 'PR1' or rtrim(left(postcode,len(postcode)-3)) = 'PR2' or rtrim(left(postcode,len(postcode)-3)) = 'PR25' or rtrim(left(postcode,len(postcode)-3)) = 'PR26' or rtrim(left(postcode,len(postcode)-3)) = 'PR3' or rtrim(left(postcode,len(postcode)-3)) = 'PR4' or rtrim(left(postcode,len(postcode)-3)) = 'PR5' or rtrim(left(postcode,len(postcode)-3)) = 'PR6' or rtrim(left(postcode,len(postcode)-3)) = 'PR7' or rtrim(left(postcode,len(postcode)-3)) = 'PR8' or rtrim(left(postcode,len(postcode)-3)) = 'PR9' or rtrim(left(postcode,len(postcode)-3)) = 'SK1' or rtrim(left(postcode,len(postcode)-3)) = 'SK13' or rtrim(left(postcode,len(postcode)-3)) = 'SK14' or rtrim(left(postcode,len(postcode)-3)) = 'SK15' or rtrim(left(postcode,len(postcode)-3)) = 'SK16' or rtrim(left(postcode,len(postcode)-3)) = 'SK2' or rtrim(left(postcode,len(postcode)-3)) = 'SK3' or rtrim(left(postcode,len(postcode)-3)) = 'SK4' or rtrim(left(postcode,len(postcode)-3)) = 'SK5' or rtrim(left(postcode,len(postcode)-3)) = 'SK6' or rtrim(left(postcode,len(postcode)-3)) = 'SK7' or rtrim(left(postcode,len(postcode)-3)) = 'SK8' or rtrim(left(postcode,len(postcode)-3)) = 'WA1' or rtrim(left(postcode,len(postcode)-3)) = 'WA10' or rtrim(left(postcode,len(postcode)-3)) = 'WA11' or rtrim(left(postcode,len(postcode)-3)) = 'WA12' or rtrim(left(postcode,len(postcode)-3)) = 'WA13' or rtrim(left(postcode,len(postcode)-3)) = 'WA14' or rtrim(left(postcode,len(postcode)-3)) = 'WA15' or rtrim(left(postcode,len(postcode)-3)) = 'WA2' or rtrim(left(postcode,len(postcode)-3)) = 'WA3' or rtrim(left(postcode,len(postcode)-3)) = 'WA4' or rtrim(left(postcode,len(postcode)-3)) = 'WA5' or rtrim(left(postcode,len(postcode)-3)) = 'WA8' or rtrim(left(postcode,len(postcode)-3)) = 'WA9' or rtrim(left(postcode,len(postcode)-3)) = 'WN1' or rtrim(left(postcode,len(postcode)-3)) = 'WN2' or rtrim(left(postcode,len(postcode)-3)) = 'WN3' or rtrim(left(postcode,len(postcode)-3)) = 'WN4' or rtrim(left(postcode,len(postcode)-3)) = 'WN5' or rtrim(left(postcode,len(postcode)-3)) = 'WN6' or rtrim(left(postcode,len(postcode)-3)) = 'WN7' or rtrim(left(postcode,len(postcode)-3)) = 'WN8' ) and webVisible = 1 AND wood = 1 AND stoveinstal = 0 AND fireplaceinstal = 0 AND doubleskinflue = 0 AND liner = 0 order by len(areas) asc
R.WILKINSONDistance = 3 Miles
Click here for full details about R.WILKINSONKiln Dried Logs UKDistance = 3 Miles
Click here for full details about Kiln Dried Logs UKASG TREE SERVICES LtdDistance = 7 Miles
Click here for full details about ASG TREE SERVICES Ltdlogical logs & kindlinDistance = 8 Miles
Click here for full details about logical logs & kindlinThe Briquette CompanyDistance = 8 Miles
Click here for full details about The Briquette Companyribble valley log suppliesDistance = 8 Miles
Click here for full details about ribble valley log suppliesRamsbottom FirewoodDistance = 9 Miles
Click here for full details about Ramsbottom FirewoodlogbustersDistance = 11 Miles
Click here for full details about logbustersM.MurphyDistance = 12 Miles
Click here for full details about M.MurphyBuy Firewood Direct LimitedDistance = 13 Miles
Click here for full details about Buy Firewood Direct LimitedBuy Firewood DirectDistance = 13 Miles
Click here for full details about Buy Firewood DirectGibsons FirelogsDistance = 15 Miles
Click here for full details about Gibsons FirelogsLogs 1 LimitedDistance = 15 Miles
Click here for full details about Logs 1 LimitedCPL Manchester CoalDistance = 15 Miles
Click here for full details about CPL Manchester CoalManchester CoalDistance = 15 Miles
Click here for full details about Manchester CoalFire fuelsDistance = 15 Miles
Click here for full details about Fire fuelsDirect Wood FuelDistance = 15 Miles
Click here for full details about Direct Wood FuelKindling GreenDistance = 17 Miles
Click here for full details about Kindling Greennorthwest stovesDistance = 17 Miles
Click here for full details about northwest stovesbasils brushDistance = 18 Miles
Click here for full details about basils brushBeacon Log ServicesDistance = 18 Miles
Click here for full details about Beacon Log ServicesParbold LogsDistance = 18 Miles
Click here for full details about Parbold LogsAspinalls chimneysDistance = 19 Miles
Click here for full details about Aspinalls chimneysManchester Firewood SuppliesDistance = 21 Miles
Click here for full details about Manchester Firewood SuppliesWarrington LogsDistance = 21 Miles
Click here for full details about Warrington LogsLogs and blocks oldhamDistance = 21 Miles
Click here for full details about Logs and blocks oldhamKILN FIREWOODDistance = 21 Miles
Click here for full details about KILN FIREWOODRainford firewood suppliesDistance = 21 Miles
Click here for full details about Rainford firewood suppliesLogs2doorDistance = 21 Miles
Click here for full details about Logs2doorA. BROOKSDistance = 22 Miles
Click here for full details about A. BROOKSlytham hallDistance = 22 Miles
Click here for full details about lytham halljl logsDistance = 22 Miles
Click here for full details about jl logsMillhouse World of Wood LimitedDistance = 22 Miles
Click here for full details about Millhouse World of Wood LimitedGreater Manchester TreeStation LtdDistance = 22 Miles
Click here for full details about Greater Manchester TreeStation LtdMillhouse world of wood ltdDistance = 22 Miles
Click here for full details about Millhouse world of wood ltdBurnBestDistance = 22 Miles
Click here for full details about BurnBestSuperfire LimitedDistance = 22 Miles
Click here for full details about Superfire LimitedHouseFuelDistance = 22 Miles
Click here for full details about HouseFuelNEWTON LOG SUPPLIESDistance = 23 Miles
Click here for full details about NEWTON LOG SUPPLIESAlderwood Logs & FirewoodDistance = 23 Miles
Click here for full details about Alderwood Logs & FirewoodS.EATON FUELSDistance = 24 Miles
Click here for full details about S.EATON FUELSFitch Recycling SolutionsDistance = 25 Miles
Click here for full details about Fitch Recycling SolutionsSeasons LogsDistance = 25 Miles
Click here for full details about Seasons LogsWest Lancs LogsDistance = 25 Miles
Click here for full details about West Lancs Logsairedale wood manDistance = 26 Miles
Click here for full details about airedale wood manOak & Willow Garden LtdDistance = 26 Miles
Click here for full details about Oak & Willow Garden LtdRavenroyd FarmDistance = 26 Miles
Click here for full details about Ravenroyd FarmBingley Log ServicesDistance = 26 Miles
Click here for full details about Bingley Log ServicesAble Tree SurgeonsDistance = 27 Miles
Click here for full details about Able Tree SurgeonsD N QuinnDistance = 27 Miles
Click here for full details about D N QuinnThe Compost ShopDistance = 28 Miles
Click here for full details about The Compost Shoppearson fuels ltdDistance = 28 Miles
Click here for full details about pearson fuels ltdFirewood ShopDistance = 28 Miles
Click here for full details about Firewood ShopLHF Logs and Coal SuppliesDistance = 28 Miles
Click here for full details about LHF Logs and Coal SuppliesLocal LogsDistance = 29 Miles
Click here for full details about Local LogsGreenfires Chimney and Stove servicesDistance = 29 Miles
Click here for full details about Greenfires Chimney and Stove servicesCPL Lancashire CoalDistance = 29 Miles
Click here for full details about CPL Lancashire CoalGlossop coal and log suppliesDistance = 29 Miles
Click here for full details about Glossop coal and log suppliesGlossop Firewood and Fuel Suppliers LimitedDistance = 29 Miles
Click here for full details about Glossop Firewood and Fuel Suppliers Limitedbowker landscapesDistance = 30 Miles
Click here for full details about bowker landscapes
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.