SQL SERVER||How many ways to get domain name from email column in a table?

Published: 03 January 2023
on channel: LearnSQLtoSSIS

224

By using 8 string functions, we can extract 5 ways to get domain name from email column in SQL

SUBSTRING
CHARINDEX
PATINDEX
STUFF
LEFT
RIGHT
LEN
REVERSE

SUBSTRING(email,CHARINDEX('@',email)+1,LEN(email)) AS Domain_Name_SUBSTRING
,SUBSTRING(email,PATINDEX('%@%',email)+1,LEN(email)) AS Domain_Name_SUBSTRING
,STUFF(email,1,CHARINDEX('@',email),'')AS Domain_Name_STUFF
,REVERSE(LEFT(REVERSE(email),CHARINDEX('@',REVERSE(email))-1))AS Domain_Name_LEFT
,RIGHT(email,LEN(email) - CHARINDEX('@',email)) AS Domain_Name_RIGHT

Watch video SQL SERVER||How many ways to get domain name from email column in a table? online without registration, duration hours minute second in high quality. This video was added by user LearnSQLtoSSIS 03 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 224 once and liked it 5 people.