UPDATE tbVendorShortName SET ShortName='McLane'
WHERE ShortName='MCLANE COMPANY INC'
;
UPDATE tbVendorShortName SET ShortName='QCD'
WHERE ShortName='Quality Custom Distribution'
;
UPDATE tbVendorShortName SET ShortName='PARISHABLES'
WHERE ShortName='Parishables Food Services'
;
UPDATE tbVendorShortName SET ShortName='MB'
WHERE ShortName='MARTIN BROWER'
;
UPDATE tbVendorShortName SET ShortName='Food Authority South'
WHERE ShortName='Food Authority South'
;
UPDATE tbVendorShortName SET ShortName='Food Authority of Massachusetts'
WHERE ShortName='Food Authority of Massachusetts'
;
UPDATE tbVendorShortName SET ShortName='CFA Supply'
WHERE ShortName='CFA Supply'
;
UPDATE tbVendorShortName SET ShortName='FLANAGAN'
WHERE ShortName='Flanagan Foodservice'
;
UPDATE tbVendorShortName SET ShortName='Plaza'
WHERE ShortName='Plaza Food Systems'
;
UPDATE tbVendorShortName SET ShortName='Chick-fil-A Inc'
WHERE ShortName='Chick-fil-A Inc'
;
UPDATE tbVendorShortName SET ShortName='Sysco Hawaii'
WHERE ShortName='Sysco Hawaii'
;
GO