SQLServerCentral Article

TSQL Challenge 32 - Clean up phrases by removing noise words

,

The idea of this challenge is to clean up the phrase from the words identified as 'noise' words, but only when these words appear at the begining or the end of the string, not in the middle of the string.

Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentenses.

http://beyondrelational.com/blogs/tc/archive/2010/06/14/tsql-challenge-32-clean-up-phrases-by-removing-noise-words.aspx

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating