UPDATE tbZone SET Zone='CFA Supply-Cartersville GA DC 2'
WHERE ZoneTypeId=46 AND Zone='CFA Supply Cartersville GA 726'
;
UPDATE tbZone SET Zone='CFA Supply-Mebane'
WHERE ZoneTypeId=46 AND Zone='CFS Mebane NC'
;
UPDATE tbZone SET Zone='Chick-fil-A Inc-CFA Contingency'
WHERE ZoneTypeId=46 AND Zone='CFA Contingency'
;
UPDATE tbZone SET Zone='FA-Boston MA'
WHERE ZoneTypeId=46 AND Zone='FA Boston MA'
;
UPDATE tbZone SET Zone='FA-Jessup MD'
WHERE ZoneTypeId=46 AND Zone='FA Jessup MD'
;
UPDATE tbZone SET Zone='Flanagan - Kitchener ON'
WHERE ZoneTypeId=46 AND Zone='Flanagan Foodservice Kitchener ON CAN'
;
UPDATE tbZone SET Zone='MB-Atlanta GA'
WHERE ZoneTypeId=46 AND Zone='MB Atlanta GA'
;
UPDATE tbZone SET Zone='MB-Baton Rouge LA'
WHERE ZoneTypeId=46 AND Zone='MB Baton Rouge LA'
;
UPDATE tbZone SET Zone='MB-Coatesville PA'
WHERE ZoneTypeId=46 AND Zone='MB Coatesville PA'
;
UPDATE tbZone SET Zone='MB-Little Rock AR'
WHERE ZoneTypeId=46 AND Zone='MB Little Rock AR'
;
UPDATE tbZone SET Zone='MB-Manassas VA'
WHERE ZoneTypeId=46 AND Zone='MB Manassas VA'
;
UPDATE tbZone SET Zone='MB-McCook IL'
WHERE ZoneTypeId=46 AND Zone='MB McCook IL'
;
UPDATE tbZone SET Zone='MBM-Elkhorn WI'
WHERE ZoneTypeId=46 AND Zone='McLane Elkhorn WI'
;
UPDATE tbZone SET Zone='MBM-Lewisville TX'
WHERE ZoneTypeId=46 AND Zone='McLane Lewisville TX'
;
UPDATE tbZone SET Zone='MBM-Lockbourne OH'
WHERE ZoneTypeId=46 AND Zone='McLane Lockbourne OH'
;
UPDATE tbZone SET Zone='MBM-Macon GA'
WHERE ZoneTypeId=46 AND Zone='McLane Macon GA'
;
UPDATE tbZone SET Zone='MBM-Sumner WA'
WHERE ZoneTypeId=46 AND Zone='McLane Sumner WA'
;
UPDATE tbZone SET Zone='MB-St John MI'
WHERE ZoneTypeId=46 AND Zone='MB St John MI'
;
UPDATE tbZone SET Zone='MB-Whitewater WI'
WHERE ZoneTypeId=46 AND Zone='MB Whitewater WI'
;
UPDATE tbZone SET Zone='Mclane - Manteca CA'
WHERE ZoneTypeId=46 AND Zone='McLane Manteca CA'
;
UPDATE tbZone SET Zone='McLane-Memphis TN'
WHERE ZoneTypeId=46 AND Zone='McLane Memphis TN'
;
UPDATE tbZone SET Zone='McLane-Houston TX'
WHERE ZoneTypeId=46 AND Zone='McLane Houston TX'
;
UPDATE tbZone SET Zone='McLane-Oklahoma City OK'
WHERE ZoneTypeId=46 AND Zone='McLane Oklahoma City OK'
;
UPDATE tbZone SET Zone='McLane-Riverside CA'
WHERE ZoneTypeId=46 AND Zone='McLane Riverside CA'
;
UPDATE tbZone SET Zone='McLane-Shawnee KS'
WHERE ZoneTypeId=46 AND Zone='McLane Shawnee KS'
;
UPDATE tbZone SET Zone='Mclane-Milwaukee WI'
WHERE ZoneTypeId=46 AND Zone='McLane Milwaukee WI'
;
UPDATE tbZone SET Zone='Plaza - Puerto Rico'
WHERE ZoneTypeId=46 AND Zone='Plaza Caguas PR'
;
UPDATE tbZone SET Zone='PARISHABLES - ATL'
WHERE ZoneTypeId=46 AND Zone='Parishables Austell GA'
;
UPDATE tbZone SET Zone='QCD - Indianapolis'
WHERE ZoneTypeId=46 AND Zone='QCD Indianapolis IN'
;
UPDATE tbZone SET Zone='QCD-Apopka FL'
WHERE ZoneTypeId=46 AND Zone='QCD Apopka FL'
;
UPDATE tbZone SET Zone='QCD-Aurora CO'
WHERE ZoneTypeId=46 AND Zone='QCD Denver CO'
;
UPDATE tbZone SET Zone='QCD-Miami FL'
WHERE ZoneTypeId=46 AND Zone='QCD Miami FL'
;
UPDATE tbZone SET Zone='QCD-Minneapolis MN'
WHERE ZoneTypeId=46 AND Zone='QCD Minneapolis MN'
;
UPDATE tbZone SET Zone='QCD-Phoenix AZ'
WHERE ZoneTypeId=46 AND Zone='QCD Phoenix AZ'
;
UPDATE tbZone SET Zone='QCD-Pineville NC'
WHERE ZoneTypeId=46 AND Zone='QCD Charlotte'
;
UPDATE tbZone SET Zone='QCD-Salt Lake City UT'
WHERE ZoneTypeId=46 AND Zone='QCD Salt Lake City UT'
;
UPDATE tbZone SET Zone='QCD-San Antonio TX'
WHERE ZoneTypeId=46 AND Zone='QCD-San Antonio TX'
;
UPDATE tbZone SET Zone='QCD-Suffolk VA'
WHERE ZoneTypeId=46 AND Zone='QCD Suffolk VA'
;
UPDATE tbZone SET Zone='Sysco Hawaii - Maui'
WHERE ZoneTypeId=46 AND Zone='Sysco Hawaii - Maui'
;
UPDATE tbZone SET Zone='Sysco Hawaii - Oahu'
WHERE ZoneTypeId=46 AND Zone='Sysco Hawaii - Oahu'
;
GO
