How can I count the number of instances a word (ie. "Keyword") appears in a Database field?
Select Count(*)as keywordCount FROM <table> Where <field> like '%<Keyword>%'<BR><BR>Of course this will be limited to counting one for each row it occurs in even if it is in a row 10 times
Yes SQL server
Right, thats what Im currently using, wondering if there is any way to see if it does contain that word 10 times
utilizing PatIndex and CharIndex<BR><BR>I don't recall seeing a built in UDF to count words.