No, there shouldn't he any problems storing a comma delimited list-- it's just bad normalization since a list isn't an atomic value.
If you are searching for "1" make sure you account for the following lists: 1,2,3 3,2,1 2,1,3 "%,1,%" is only work for one of those. ~Brad > would a comma delimited list in a coldfusion query object cause this > error? and if so how can i get around it > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4