UPDATE tbVendorShortName SET ShortName='MCLANE COMPANY INC'
WHERE ShortName='McLane'
;
UPDATE tbVendorShortName SET ShortName='Quality Custom Distribution'
WHERE ShortName='QCD'
;
UPDATE tbVendorShortName SET ShortName='Parishables Food Services'
WHERE ShortName='PARISHABLES'
;
UPDATE tbVendorShortName SET ShortName='MARTIN BROWER'
WHERE ShortName='MB'
;
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 Foodservice'
WHERE ShortName='FLANAGAN'
;
UPDATE tbVendorShortName SET ShortName='Plaza Food Systems'
WHERE ShortName='Plaza'
;
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
