Did you try listFind()? m!ke
-----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2008 4:38 PM To: CF-Talk Subject: How do I limit the "contains" function? Hi, all... How do I limit the "contains" (or in this case "does not contain") function so that it won't find a string when it's part of a larger string? Exempli Gratis... I have a list of 3 city names: Esabel,Esabell,Esabelle This code: <cfif #valueList(get_approved_cities.approved_city)# does not contain #property_city#> will return that all three cities are contained in the list because the string, "Esabel", is contained in all three city names, etc. How would I modify the code to return "Esabelle", but not Esabel nor Esabell? Using commas is tricky because the last city name in the list isn't followed by a comma. (Tried that one...) Ideas? Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
