Any chance you can change that db schema, or is it too late? I would think it might be a big headaches to maintain such a scheme. It's also likely to be much slower than some other approaches.
If you're stuck with the current setup, just try something like this: select blah from Functions where 4 IN (select UserIDList from Functions where FunctionId = 1) </rob> -----Original Message----- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 6:43 PM To: CF-Talk Subject: Query Issue Howdy List! Can someone please 'gimmie a thread' on this? (ie: Brain thread, as in cpu thread) I have an existing database with a field named 'AccessList'. This field is a comma delimited list of IDs (numeric only). These IDs are for users who are to be granted access to a function. For example one entry would be 4,15,26,44,101,9. I am trying to devise a query that will check the field for a single userID. Say 4 for example... note that 44 also exists in the list. My fumbling attempts to devise a way using LIKE and IN are not working. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
