Something to get you started:
Put the keywords into a table and join with that table. See the example below. If you have more than one keyword to be removed in a single sentence, the update statement would need to be run multiple times. Also, it is not quite perfect - if a keyword happens to be the starting or ending portion of a sentence, that gets replaced as well.CREATE TABLE #keywords(word VARCHAR(32));
INSERT INTO #keywords VALUES
('Blu R'),('Dvd'),('Blu Ray'),('Dvd/bl'),('Dvd & Blu'),('D/b'),('Dvd Box Se'),('Dvd & Blu Ray'),('D/bl'),('D/');
CREATE TABLE #test(sentence VARCHAR(255));
INSERT INTO #test VALUES ('Bad boys dvd'),('Advd'),('xyz');
UPDATE t SET
sentence = COALESCE(REPLACE(REPLACE(t.sentence,' '+word,''),word+' ',''),t.sentence)
FROM
#test t
LEFT JOIN #keywords k ON t.sentence LIKE '%'+k.word+'%'
SELECT * FROM #test;
DROP TABLE #test
DROP TABLE #keywords
Function to replace words
Posted - 01/17/2013 : 14:12:56
