>>>> 2013/01/31 22:24 -0600, Peter Brawley >>>> Is this what you mean?
Select, pricelist If( !IsNull(specialprice) And specialprice < unitprice And CurDate() Between startingDate And endingDate, specialprice, unitprice ) as used_price >From catalog Where itemid='WB314'; PB <<<<<<<< Maybe this is gilding the lily, but if "specialprice" is null, then specialprice < unitprice is not true--and maybe if the null-test is left out it is less clear.... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql