I have a column in a database called Description and I want to strip out all the individual words that exist in this column into a separate table and count the occurances.
As part of this process the column with be turned to UPPER(Decsription)
so for example
amazon and ebay exist
returns temp table with 2 fields
how and is this possible