• its not much better but here is another way that retrives any email address if its the last test in your string and has a space.

    select reverse(substring(reverse(Email_Address),0,charindex(' ',reverse(Email_Address))))

    from DBO.Email_Checker

    ***The first step is always the hardest *******