Hot damn. Thank you. Got it working by adding this section:

SET @strCount=0

SET @Count =1

Start6: --Label

SELECT @strFind=SUBSTRING(@email,@Count,2)

IF @strFind LIKE '%.@%'

OR @strFind LIKE '%@.%'

BEGIN

SET @chkEmail = 106

GOTO RR

END

SET @count=@Count+1

IF @Count <= len(@email)

BEGIN

Goto Start6

END

END

RR:

RETURN @ChkEmail

END

/*

SELECT dbo.CHKEmail('put email here') AS INVALID

*/