SQL multiple replace <p>I want to read the company table and take out all possible suffixes from the name. Here's what I have so far:</p> <pre><code>declare @badStrings table (item varchar(50)) INSERT INTO @badStrings(item) SELECT 'company' UNION ALL SELECT 'co.' UNION ALL SELECT 'incorporated' UNION ALL SELECT 'inc.' UNION ALL SELECT 'llc' UNION ALL SELECT 'llp' UNION ALL SELECT 'ltd' select id, (companyname = Replace(name, item, '') FROM @badStrings) from companies where name != '' </code></pre>