I think this is going to be one of those things that has an easy and elegant answer I just wasnt clever enough to think of...
I want to count the occurrencies of a user entered string within a varchar column of the whole table...NOT THE ROWCOUNT as one row may contain the numerous times.
Can think of numerous ways to do it on the ASP end is there an SQL solution...?
Cheers
Rolf