Start a new topic
Answered

Extracting username from an email address in the SQL server.

For example fjama@semarchy.com. So here is username - fjama, How can I return this expression when using SQL Server?


Best Answer

You can use the SEMQL Expression 

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


1 Comment

Answer

You can use the SEMQL Expression 

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


Login to post a comment