I used to do just this sort of thing. Issue was, if the item you were looking for was at the start or end of the list, i.e. "1,2,3", you couldn't find it using '%,1,%'.
So I would toss on extra commas (or whatever character I was using as a delimeter, like a pipe) on each end of the list string before throwing it in the db, a la ",1,2,3,". That way the '%,X,%' bit would work no matter what. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
