> WHERE > (dsp_millthou='thousand' AND dsp_amount>#Int(req.fromVALUE/1000)#) > OR > (dsp_millthou='million' AND dsp_amount>#Int(req.fromVALUE/1000000)#) > OR > (dsp_millthou='billion' AND dsp_amount>#Int(req.fromVALUE/1000000000)#)
If I use a varient of this, I'm not even sure I need the CASE statement at all... In theory then... Assuming form.fromVALUE form.toVALUE form.fromMILLTHOU form.toMILLTHOU req.frommultiplier (set depending on fromMILLTHOU choice...) req.tomultiplier (set depending on toMILLTHOU choice...) in the Query WHERE (dsp_millthou = '#form.fromMILLTHOU#' and dsp_amount > #Int(req.fromVALUE/req.frommultiplier)#) AND (dsp_millthou = '#form.toMILLTHOU#' and dsp_amount > #Int(req.toVALUE/req.tomultiplier)#) That outta work, shouldn't 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:308522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4