title: Filter the database
body: <p>I need to filter the <code>sql</code> database based on the user's input for 4 columns in an <code>asp.net</code> web Application. This situation, they can select or not all four columns or one column or 2 or etc. All  I have is 2^4(16) possibilities. Whats the best method to filter?</p>
  
  <p>My <code>gui</code> screenshot:</p>
  
  <p><a href="https://i.stack.imgur.com/0zXb7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0zXb7.jpg" alt="screenshot"></a></p>
  
  <p>Please guide me.</p>
  
  <p>I wrote a query for selection of one of four:</p>
  
  <pre><code>SELECT acct_number AS AccountNo,
      cust_lname AS Name 
  FROM List 
  WHERE (ordr_date='" + orderdate + "' 
      OR reader_code='" + rdrCode + "' 
      OR dly_pack_no='" + dlyPack + "' 
      OR walk_seq='" + wlkSeq + "')
  </code></pre>