Extraction queries with variable last part of the search term
<p>I have a problem with an extraction query.</p>

<p>I want to extract all records that begin with exactly one name.</p>

<p>The problem:</p>

<ul>
<li>Not always the end of the name is this extension;</li>
<li>When they are present, they have no fixed length.</li>
</ul>

<p>Example:</p>

<p>TabNames</p>

<pre><code>id | Name

1 | Mike
2 | Mike Nell-1
3 | Mike-2
4 | Robert-1
5 | Mike Rio-NN
6 | Mike-Orio-2
.....
</code></pre>

<p>Name searched for: 'Mike'</p>

<p>Desired outcome:</p>

<pre><code>Mike, Mike-2
</code></pre>

<p>If interested, I use SQL Server.</p>

<p>How can I do?</p>