How to masked the email ID in SQL Server?

Question

Khushi Singh · Answer

To mask an email ID in SQL Server, one can use the STUFF function to remove some characters, put * on the result set, and put back some characters at the end.

Example Query:

SELECT 
   Email,
   STUFF(Email, CHARINDEX('@', Email) - 3, 3, '***') AS MaskedEmail
FROM 
   YourTable;

Explanation:

CHARINDEX('@', Email): Finds the position of the @ symbol in the email.
STUFF: Replaces the characters starting 3 characters before the @ with ***.

Hope it helps!!

forum

How to masked the email ID in SQL Server?

Can you answer this question?

1 Answers