Date: 11/24/08 (SQL Server)    Keywords: web

I want to search a text field to return multiple instances of my
search criteria so I can apply a count to find out how many time
it appears in that particular piece of text. For EG: searching a
webpage stored in a DB field called content using %

Source: http://community.livejournal.com/sqlserver/68380.html