Skip to main content
Fathia JamaSemarchy Team
Sr. Customer Success Consultant at Semarchy

I will like to return only the username of an email address. For example How can I return this expression when using SQL Server?

Where am I?


Fathia Jama
Fathia Jama Semarchy Team

You can use the SEMQL Expression

LEFT(Record1.CleansedEmail, CHARINDEX('@',Record1.CleansedEmail) - 1)

Related Discussions