ListFind will do the trick: <cfset myList = "1,2,3" /> <cfset myPos = ListFind(myList, 3) />
myPos will be set to the position in the list of the number 3, which in this case is 3. Hope that helps, Matt On Thu, 4 Nov 2004 13:45:10 -0600, Kevin Fricke <[EMAIL PROTECTED]> wrote: > I have a comma delimited list of numbers in a field. What is the language > for the query to see if a particular number is in that list?? > > Thanks! > > Kevin Fricke > > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
