First time I've posted in this group so go easy on me :-). Hopefully
somebody can help. My website runs off an SQL database and I'm trying to
write a query in Microsoft SQL Query Analyser.
So, I've got a table called tbl_outgoing, and within it is a column called
number. A typical field contains text such as below:
There can be anything from 1 to 100+ <number>xxxx</number> entries in a
field. I need a query to count the amount of times <number> (or 'number'/2)
occurs in the whole column.
*** FREE BIG BROTHER ALERTS ***
Free mobile alerts
3 months free insurance