title: sql search query containing first name should first in search
body: <p>I have one employee table containing data like below</p>
  
  <pre><code>Id Name
  1  Yogesh
  2  Darshan
  3  Haresh
  4  Ramesh
  5  Suresh
  6  Ashvin 
  </code></pre>
  
  <p>i want to search name from employee table.
  my query is </p>
  
  <pre><code>SELECT Name FROM Client_Master WHERE Name LIKE'%" + txtname.text + "%'";
  </code></pre>
  
  <p>now i search A on text box then it display first Darshan, Haresh ..Before Ashvin..</p>
  
  <p>My question is if i press A on textbox then first record sholud be Ashin after than Darshan, Haresh, ....will come..</p>
  
  <p>So please suggest me query regarding this.</p>