SELECT
CASE WHEN Right(Email, 5) = ‘a.com’
THEN
LEFT(Email, LEN(Email) - 21) + UPPER(SUBSTRING(Email, LEN(Email) - 20, 1)) + SUBSTRING(Email, LEN(Email) - 19, 6) + UPPER(SUBSTRING(Email,
LEN(Email) - 13, 1)) + SUBSTRING(Email, LEN(Email) - 12, 6) + UPPER(SUBSTRING(Email, LEN(Email) - 6, 1)) + RIGHT(Email, 6)
ELSE
LEFT(Email, LEN(Email) - 11) + UPPER(SUBSTRING(Email, LEN(Email) - 10, 1)) + SUBSTRING(Email, LEN(Email) - 9, 2)
+ UPPER(SUBSTRING(Email, LEN(Email) - 7, 1)) + Right(Email,7)
AS Email
FROM dbo.AD_List
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
Open in new window