Checking Validity of Email Address in Store Proc
                            
                         
                        
                     
                 
                
                    CREATE PROC proc_Email
(
@Email varchar(100)=null,
@errormsg varchar(50)=null,
)
I want to check whether email address is valid or not..? how to proceed..?
Insert into table(..............)
values(....................)