title: Order rows according to which condition is met?
body: <p>I have a pretty simple question: Is it possible to order the rows retrieved according to the which condition is met?
  For example, I have a table of people, and I want to retrieve all people whose names begin with an "I", or end with an "ster", or contain "lo", ordered according to which condition of these is met. First the rows that match the first condition, then the rows that match the second, and so on. (<strong>Without duplicated:</strong> if a row meets the first condition, it shouldn't show again for the second condition)</p>
  
  <p><strong>Edit:</strong>
  I work with Visual C#, and I manage the DB with MS Access. (The file format is .mdb, if that matters)</p>
  
  <p>Thank you =)</p>