Use Jeff Moden's splitter (see Alan's signature) to split the column, LEFT join your correction table and USE FOR XML to concatenate the result (using either the replacement text or the original)