title: How can i use full text index to find records which begin with a specific character or word?
body: <p>I have the following query with <code>LIKE</code> condition:</p>
  
  <p><code>Select top 20 * from entity with(NOLOCK) where first like 'john%'</code></p>
  
  <p>The Above query will return the employee whose first name starts with John.
  Now the same query using Full-Text Index search:</p>
  
  <pre><code>Select top 20 * from entity with(NOLOCK) WHERE Contains(First,'John').
  </code></pre>
  
  <p>The above code returns all the records which contains phase john in first name.</p>
  
  <p>How to make the second query return the exact matching records, that is those beginning with <em>John</em>.</p>
  
  <p>The desired result is shown on this picture below:</p>
  
  <p><img src="https://i.stack.imgur.com/ISqYL.png" alt="Result">  </p>