Avatar of HKFuey
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

SQL Syntax to get first email on row

I need a formula that returns the first email in a list like this:

mailto:email@domain.com ; mailto:email2@domain.com ; mailto:email3@domain.com

So the result would be mailto:email@domain.com 

Anyone know how?
* SQL Server 2012 EnterpriseSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon