Update MWCAS Set [Assigned Provider] = '1' Where [Assigned Provider] in ('5', 'C', 'CHIPS', 'PALME'); Update MWCLA Set [Provider] = '1' Where [Provider] in ('5', 'C', 'CHIPS', 'PALME'); Update OHAPP Set [Provider] = '1' Where [Provider] in ('5', 'C', 'CHIPS', 'PALME'); Delete From OHVIE Where [Value] in ('5', 'C', 'CHIPS', 'PALME') and [Field] = 'Provider'; Update MWPAT Set [Assigned Provider] = '1' Where [Assigned Provider] in ('5', 'C', 'CHIPS', 'PALME'); Update MWTRN Set [Attending Provider] = '1' Where [Attending Provider] in ('5', 'C', 'CHIPS', 'PALME');