I need help with a trigger, I would like to prevent a user from inserting a blank string into a column.
At the moment the trigger below raises an error even when the txtDescription column is not blank.
Please help, I'm not sure what I'm missing:
CREATE TRIGGER trDtlIncident ON dbo.dtlIncident
IF EXISTS (SELECT * FROM dtlIncident
WHERE Convert(Varchar, txtDescription) <> '')
RAISERROR ('Incident description can not be blank.', 16, 1);