Question

In a Fabric warehouse, you have a Customer table with an EmailAddress column containing values such as 'jane.doe@contoso.com'. You need to create a query that returns only the domain portion (the text after the '@' character, e.g., 'contoso.com') as a new column named EmailDomain. Which T-SQL expression should you use?

Accepted Answer

SUBSTRING(EmailAddress, CHARINDEX('@', EmailAddress) + 1, LEN(EmailAddress)) AS EmailDomain

Answer

LEFT(EmailAddress, CHARINDEX('@', EmailAddress) - 1) AS EmailDomain

Answer

REPLACE(EmailAddress, '@', '') AS EmailDomain

Answer

TRIM('@' FROM EmailAddress) AS EmailDomain