IF (SELECT SYSTEM_USER <> 'BackEnd' AND (select cOrderType from deleted) <> 'X' AND (select cOrderType from inserted) <> 'X'>Hello,
> >CREATE TRIGGER OrderEdit ON dbo.Order >FOR INSERT, UPDATE >AS >IF (SELECT user_name()) <> 'BackEnd' or (select cOrderType from deleted) <> 'X' or (select cOrderType from inserted) <> 'X' > BEGIN > UPDATE dbo.Order > SET tEdited = GETDATE() > WHERE iOrder IN > (SELECT iOrder FROM inserted) > UPDATE dbo.Customer > SET tEdited = GETDATE() > WHERE iCustomer IN > (SELECT iCustomer FROM inserted) > END>I have also tried nesting the IF statements and failed.