select user_ID from usertbl where user_ID in (select accesslist from area where ....)
- j -----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. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
