-- This function returns 1 is passed EMAIL Address has valid syntax
-- else 0 will be returned
--
-- Example calls:
-- SELECT dbo.fncValidEmail('goodemail@NimbleUser.com') as 'GOOD'
-- SELECT dbo.fncValidEmail('bademail@NimbleUsercom') as 'BAD'
--
-- Example on how to find all of the bad email addresses in iMIS
-- SELECT ID, FULL_NAME, EMAIL FROM Name WHERE dbo.vaValidEmail(EMAIL) = 0

CREATE FUNCTION [dbo].[fncValidEmail](@EmailAddress VARCHAR(250))
RETURNS BIT
AS
BEGIN    
     DECLARE @ResultBoolean as Bit

     IF ((@EmailAddress <> '') AND (@EmailAddress NOT LIKE '_%@__%.__%'">'_%@__%.__%'))
          BEGIN
               -- Invalid

               SET @ResultBoolean = 0
          END
     ELSE
          BEGIN
               -- Valid

               SET @ResultBoolean = 1
          END

     RETURN @ResultBoolean
END