Hugh, I'd caution you to thoroughly check the results of your query.
Per your previous posts, if the PERMISSIONS value is "1,2,3" then the query will not return anything on a session.status that has a value of "1,3,2"- because they a not "LIKE" > -----Original Message----- > From: Hugh Fidgen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 05, 2007 2:53 AM > To: CF-Talk > Subject: Re: SQL select where in headache > > Thanks > > WHERE PERMISSIONS LIKE '%#session.status#%' > > Seems to have done the trick! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
