I can not get this to work how I would think it should be formatted: SELECT IF(NOW() BETWEEN sale_start AND sale_end, 'yes', 'no') That seems to work just fine However, I was under the impression that BETWEEN was to be formatted BETWEEN(va1, v2) Which leads me to: SELECT IF(NOW() BETWEEN(sale_start AND sale_end), 'yes', 'no') Which gives me a error of: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'yes', 'no') FROM products WHERE id = "75"
-- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]