E mail Validation

,

Script used to validate whether the given email address is valide or not.

Declare @UserEmail varchar(100)
SET @UserEmail  = 'test@xx.com'
If NOT (@UserEmail LIKE '[^.@]%[^.@]@[^.@]%[^.@].[^.@]%[^.@]' OR @UserEmail LIKE '%@%@%')

            Begin

                        Print ‘error’

            End

Rate

Share

Share

Rate