title: DataTable Select method
body: <p>I have a list of rows in my datatable.<br>
  Now I wish to prioritize the rows not according to <code>DESC</code> or <code>ASC</code> but based on few similarities of my variables with the row values.</p>
  
  <p>For example,<br>
  I have datatable with columns as below:</p>
  
  <pre><code>Name, Location, Age, Sex, Education..
  </code></pre>
  
  <p>And I already have some preferences of seeing those rows first which match my education and location, and those rows which doesn't match, can be after the first row.</p>
  
  <p>How do I accomplish this?<br>
  I tried setting expression in <code>SELECT statement</code> with <code>OR</code> and <code>LIKE clause</code> but I didn't seem to be getting the right answer.</p>
  
  <blockquote>
  <pre><code>DataRow[]  row = ds.Tables[0].Select("Affiliations LIKE '%" + ftr2 + "%'OR Loc_city LIKE '%" + city1 + "%'OR Edu_Hist LIKE '%" + ftr + "%'OR Work_Hist LIKE '%" + ftr1 + "%' OR Priority='true'");
  </code></pre>
  </blockquote>
  
  <p>here i dont want to be strict that i want these values only but a preference setting that i want these values first, rest can be behind it..</p>