ErcanOPAK.com

You can check the code below:

ALTER TABLE your_table
ADD CONSTRAINT chk_email CHECK(CHARINDEX('@', YourEmailColumn) > 0 OR YourEmailColumnIS NULL)

--OR you can use this one

ALTER TABLE your_table
ADD CONSTRAINT chk_email CHECK(YourEmailColumn LIKE '%_@__%.__%')