parse individual words from text field
Posted on 2005-04-05
Using only MSSQL I need to take the words in a text/varchar and pull each individual word out, check to see if it is in the "noise" list (a separate table) and ignore it if it is in the "noise" table, if it is not noise then put each word into another table with the ID field of the record the text/varchar field belongs to. So basically there would be a list of the non-noise words in a separate table with the ID of the original record where they resided in the text/varchar field. Basically creating a list of keywords that links back to the original record. I don't know the string fuctions in sql to be able to separate out the data into individual words and such.