hey charlie, thanks for pointing me in right direction. i could not get the case statement to work but the following does work...
SELECT SQL_CALC_FOUND_ROWS P.normalprice, P.saleprice, IF(P.saleprice < P.normalprice, P.saleprice, P.normalprice) as orderprice FROM product P ORDER BY orderprice works really well! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
