Pretty sure that's not going to work for you ... believe the argument on the left of the IN has to be a column, not a variable.
In any case, your best bet is to have the category_date properly normalized out into a separate table: FROM study_category INNER JOIN study_category_date ON study_category.category = study_category_date.category WHERE study_category_date.category_date = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.cat_date#"> If that's not an option, then try this: WHERE ',' & study_category.category_date & ',' LIKE '%,#arguments.cat_date#,#' Basically, by wrapping the ',' around both ends, now I have a set of ,200X, entries and so I can always test for ",200X,". >i have a table with a field (study_category.category_date) that is a >comma delimited list (2004,2005,2006,2007) stored as a NVARCHAR > >I need to see if a passed value is in the list: > > WHERE (#arguments.cat_date# in (study_category.category_date)) > >arguments.cat_date is a four digit number representing the date. > >the where clause doesn't seem to work (returns no records, when >logically it should) >Is this the right approach given the nature of the data? > > >-- >Scott Stewart >ColdFusion Developer > >Office of Research Information Systems >Research & Economic Development >University of North Carolina at Chapel Hill > >Phone:(919)843-2408 >Fax: (919)962-3600 >Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
