> > I have a varchar column (SQL server 2008) that contains comma delimited > data > thusly: A,V, C, P, PP, R, RT, L, Z,Z,Z.... > > ... > What i want to do sounds achingly simple: Count the number of occurrences > of > a 1 or 2 character list member in that list. >
Sadly the solution that jumps to my head *isn't* a simple one, involves some extra variables, a loop and a temp table. I'd love to see a short solution to this as well. I'll see if I can put my idea to code later today though. Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341272 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
