You have a SQL database in Microsoft Fabric that contains a column named Payload.

You have a SQL database in Microsoft Fabric that contains a column named Payload. Payload stores customer data in JSON documents that have the following format:

JSON

{

" date " : " 2026-01-25 " ,

" customer_email " : " user@contoso.com " ,

...

}

Data analysis shows that some customers have subaddressing in their email address; for example, user1+promo@contoso.com.

You need to return a normalized email value that removes the subaddressing, for example, user1+promo@contoso.com must be normalized to user1@contoso.com.

Which Transact-SQL expression should you use?