SELECT *
FROM Table
WHERE #form.ID# IN (AccessList)
At 03:42 PM 5/20/2002 -0700, you wrote:
>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
