title: ASP.NET - Implementing Search Functionality and SQL
body: <p>I have created a form which the user can use in order to search for transactions.  This is a picture of the form:</p>
  
  <p><img src="https://i.stack.imgur.com/F1ks8.png" alt="enter image description here"></p>
  
  <p>Now, the <strong>total price</strong> drop down list has the members:</p>
  
  <ol>
  <li>Any Price</li>
  <li>Exact Amount</li>
  <li>Below Amount</li>
  <li>Above Amount</li>
  </ol>
  
  <p>The <strong>currency</strong> drop down list has the members:</p>
  
  <ol>
  <li>Any Currency</li>
  <li>EUR</li>
  <li>USD</li>
  <li>GBP</li>
  </ol>
  
  <p>The <strong>transaction date</strong> drop down list has the members:</p>
  
  <ol>
  <li>Any Date</li>
  <li>Exact Date</li>
  <li>Below Date</li>
  <li>Above Date</li>
  </ol>
  
  <p>The <strong>transaction status</strong> drop down list has the members:</p>
  
  <ol>
  <li>Any Status</li>
  <li>Active</li>
  <li>Expired</li>
  <li>Paid</li>
  </ol>
  
  <p>All the details are being fetched from a table called <strong>Payments</strong>.</p>
  
  <p>Can someone please help me how I can go about to search in the Payments table?  Can I satisfy all the different possibilities using one SQL statement?  Or do I have to use multiple SQL statements?  Can someone please give me a template of an SQL statement that can be used to satisfy the different possibilities?  Please help since SQL is not my strongest point.  Thank you :)</p>