May I know whether there is any way to prevent a data of incorrect format to go into a column ? I have a table in which I store email address. I need to ensure that only a proper email address (format as defined by a regular expression) go to that column. If format is not according to the regular expression, it should prevent insertion / updation of that record.
I need to do this with the help of SQL server feature itself rather than using a script in my web program.
May I know whether this is possible in SQL Server 2000 ?