Do you mean in SQL, like: Select * from users where userid in(#myUserIDList#)
Or using a cf function like: <cfif listfind(#myuseridlist#, #useridinquestion#)>do something</cfif> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Fricke Sent: Thursday, November 04, 2004 1:45 PM To: CFLIST Subject: query of a list 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 ---------------------------------------------------------- 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
