IN works the other way round I think - say you have a list of values and you want to pull all records with any of those values:
WHERE name IN (will,john,ray) -----Original Message----- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: 09 January 2008 16:57 To: CF-Talk Subject: SOT sql question I think I need to be using 'IN' within my WHERE clause but I can't seem to get it to work. I have a column with a comma delimited list. This is the latest attempt and it craps out too. SELECT.. ....WHERE JobFileJob = #session.jobId# AND '#session.UserRole#' IN (JobFileAccessLevel) JobFileAccessLevel is a field in the database table that contains a comma delimited list of access levels. Maybe I'm barking up the wrong tree entirely. What I'm trying to do is. ...WHERE jobFileJob=#session.jobId# and jobFileAccessLevel CONTAINS '#session.UserRole#' But I don't think 'contains' exists. Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
