i realize that, but what if i want to run a query on the list? for example
select ID from Students where ???? I want to pull any student which has an A or B in the list. The grades field could have the following data "A,B,D,E" or just "A" Make any sense? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matt Woodward Sent: Thursday, November 04, 2004 1:51 PM To: [EMAIL PROTECTED] Subject: Re: query of a list 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 ---------------------------------------------------------- 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
