It looks like the list has a random order. Is that the case or is it in alphabetical order? Do you use user defined functions?
Regardless, check this out: http://www.sqlteam.com/article/parsing-csv-values-into-multiple-rows The key is the following: *SELECT Author, NullIf(SubString(',' + Phrase + ',' , ID , CharIndex(',' , ',' + Phrase + ',' , ID) - ID) , '') AS Word FROM Tally, Quotes WHERE ID <= Len(',' + Phrase + ',') AND SubString(',' + Phrase + ',' , ID - 1, 1) = ',' AND CharIndex(',' , ',' + Phrase + ',' , ID) - ID > 0* >From this template it looks like you could create a view with a column for each value and then use a statement similar to this that groups by value and returns count. J - Ninety percent of politicians give the other ten percent a bad reputation. - Henry Kissinger Politicians are people who, when they see light at the end of the tunnel, go out and buy some more tunnel. - John Quinton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:341281 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
