I'm looking for a calculation field that would allow the validation of
an email address when entered in the database. It should check if there
or at the end ect...
Does anyone have the kind of calculation?
I am currently not at a pc with sql server 2000 so this
may seem like a silly question but will the trigger below
work? I am trying to create a validation Trigger that is
attached to the 'Email' field in the table 'tblPatients',
which will raise an error if a user enters an
inappropriate email address.
CREATE TRIGGER uTR_ValEMail ON tblPatients
RAISERROR('Inappropriate Email entered', 16, 1)
Should I use a constraint rather than a Trigger for this