If you have CF8, you can use reMatch(). If you don't have CF8, you can use reFind(), but it is not as easy.
Depending on the length of the string, I would have the database perform a replace() operation when querying the value. I would replace the term with a special character such as the bel or tab characters. Then, I would use listLen() to see how many list items exist. M!ke -----Original Message----- From: Web Exp [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 8:50 AM To: CF-Talk Subject: number of times Hi. I have a large chunk of text/html-text in the database and I need to find out the number of times the term "fantabulous" occurs in it. Any CF function/UDFs that I can use? Any ideas please? Thanks, k ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4