- 

UPDATE aqorders SET orderstatus='cancelled'

                WHERE (NOT datecancellationprinted IS NULL OR

                       datecancellationprinted<>'0000-00-00');