title: use where clause to search from a substring SQL Server
body: <p>Hi I have column which contains below values:</p>
  
  <pre><code>names
  -----------------
  johnDoeKing
  Joseph
  MaxSecond
  Plank
  -----------------
  </code></pre>
  
  <p>Now I have an input string:</p>
  
  <pre><code>johnDoeMaxAlexPaul
  </code></pre>
  
  <p>is there a way I can use where clause which will return JohnDoeKing and MaxSecond from my column when I search with this input string in where clause ?</p>