title: Advanced search query using sql and asp.net
body: <p>I have a table [Users] with FName, LName and City as 3 columns. I want to implement a search algorithm that results from the 3 columns with the AND on top and ORed results appended to it.</p>
  
  <p>For eg: </p>
  
  <ol>
  <li>Raju Ram Bangalore</li>
  <li>Ram Raju Hyderabad</li>
  <li>Krishna Raju Chennai</li>
  </ol>
  
  <p>when I search for <strong>Raju Chennai</strong> it should result in all the <strong>3</strong> records with <strong>3rd record</strong> on top as it is the exact match and other 2 can be followed. How can I achieve this? Please advise.</p>