<div>
DECLARE @SourceString VARCHAR(500) = 'mailto:email@domain.com ; mailto:email2@domain.com ; mailto:email3@domain.com'<br><br>SELECT RTRIM(SUBSTRING(@SourceString, 1, CHARINDEX(';', @SourceString) - 1))
</div>


<div>
Hi Brian,<br><br>Looks promising but getting 'Invalid left or Substring function' Even after adding Case When 'mailto:email@domain.com' &gt;''<br><br><br>
</div>


IT Technical

HKFuey

<div>
That works!, thank you very much.
</div>


<div>
Due to the surprisingly complex grammar for e-mail addresses, e,.g. an valid address may contain a comment, you better scan for the delimiter, thus the mailto. E.g. something like<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-43283884-1"><span>--DECLARE @SourceString NVARCHAR(4000) = N'nope, none here';</span>
<span>DECLARE @SourceString NVARCHAR(4000) = N'mailto:email@domain.com ; mailto:email2@domain.com ; mailto:email3@domain.com';</span>
<span></span>
<span>DECLARE @FirstMailTo INT = PATINDEX(N'%mailto:%', @SourceString);</span>
<span>DECLARE @SecondMailTo INT = PATINDEX(N'%mailto:%', SUBSTRING(@SourceString + N';mailto:', @FirstMailTo + 7, 4000));</span>
<span>DECLARE @FirstAddress NVARCHAR(4000) = IIF(@FirstMailTo &gt; 0, SUBSTRING(@SourceString, @FirstMailTo + 7, @SecondMailTo - @FirstMailTo), @SourceString);</span>
<span></span>
<span>SELECT @FirstMailTo ,</span>
<span>       @SecondMailTo ,</span>
<span>       @FirstAddress;</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content fr-view">
I need a formula that returns the first email in a list like this:<br><br>mailto:email@domain.com ; mailto:email2@domain.com ; mailto:email3@domain.com<br><br>So the result would be&nbsp;mailto:email@domain.com&nbsp;<br><br>Anyone know how?
</div>
</div>



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 Syntax to get first email on row

SQL Server 2012 Enterprise

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.