> but what is the query syntax for the reverse scenario when the > multiple values passed by a form are NOT IN that particular data set?
You should have tried what you wrote, because that's what it is: NOT IN So: SELECT stuff FROM somewhere WHERE id IN (1,2,3); Can be inverted to: SELECT stuff FROM somewhere WHERE id NOT IN (1,2,3); ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328774 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
