title: Make exact match show at top of internal partial match T-SQL query
body: <p>Suppose you have a query that looks like so:</p>
  
  <pre><code>SELECT * FROM client
  WHERE identifyingnumber LIKE '%86%'
  </code></pre>
  
  <p>Sometimes there might be an exact match, meaning the identifyingnumber is 86.  What's the best way of making the record with that exact match to the top of the query?</p>