On Fri, Oct 31, 2008 at 11:09 AM, Dee Ayy <dee.ayy@xxxxxxxxx> wrote: > ... > IF OLD.ShipDate != NEW.ShipDate AND NEW.ShipDate IS NOT NULL THEN > ... The following seems to work. Is it correct and not too verbose? IF (OLD.StatusShipDate IS NULL AND NEW.StatusShipDate IS NOT NULL) OR (OLD.StatusShipDate != NEW.StatusShipDate AND NEW.StatusShipDate IS NOT NULL) THEN -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
