Thanks ! Barry >I believe you have to do CONTAINS "##" to escape the pound sign. > >I think I found the problem. > >In my Database, I found some entries like "Acme # 1". > >Because I have a large DB, how can I display only the names with the >symbol "#" in them. > >For Example: > ><cfoutput query="ratings"> ><cfif #ratings.fdd_name# CONTAINS "#"> >#ratings.fdd_name# ></cfif> ></cfoutput> > >But this query does not work. > >Barry
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
