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

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

Where am I?

In Semarchy Community you can ask and answer questions and share your experience with others!

Fathia Jama
Fathia Jama Semarchy Team

You can use the SEMQL Expression

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

Related Discussions