set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
--select [dbo].[fnAppEmailCheck] ('pankaj.pareek@Eedtray.com.aisa')
ALTER FUNCTION [dbo].[fnAppEmailCheck](@email VARCHAR(255))
RETURNS bit as BEGIN
DECLARE @valid bit
IF @email IS NOT NULL
SET @email = LOWER(@email)
SET @valid = 0
IF @email like '[a-z,0-9,_,-]%@[a-z,0-9,_,-]%.[a-z]%'
AND @email NOT like '%[,";:=~!#$%*?()+}{]%'
AND @email NOT like '%@%@%'
AND CHARINDEX('.@',@email) = 0
AND CHARINDEX('..',@email) = 0
AND CHARINDEX(',',@email) = 0
AND RIGHT(@email,1) between 'a' AND 'z'
SET @valid=1
RETURN @valid
END
