I have the following scenario John Doe [email protected] john [email protected]
I want away that I can detect the first right space and just exclude everything to the left so I just get the email address of the person. So: John Doe [email protected] should be [email protected] john [email protected] should be [email protected]
This is what i have
Declare @test varchar(50)
Select @test = 'John Doe [email protected]'
SELECT Right(@test, CHARINDEX(' ', @test))
This is only giving me the email.com!
Thank you.
Declare @test varchar(50)
Select @test = 'John Doe [email protected]'
SELECT RIGHT(@test, CHARINDEX(' ', REVERSE(@test)-1))
or a safer approach (if there are strings without space separator):
Declare @test varchar(50)
Select @test = '[email protected]'
SELECT
CASE
WHEN CHARINDEX(' ', REVERSE(@test)) > 0 THEN RIGHT(@test, CHARINDEX(' ', REVERSE(@test))-1)
ELSE @test
END