title: How to select by date entered by the user?
body: <p>I am using the below query to run an sql statement. It works fine. I wish to know how I can modify the query to select by a date which the user enters in ASP.NET. This means that I need to modify the part:</p>
  <pre><code>WHERE TRANSACTION_DATE = '02-AUG-2006'
  </code></pre>
  <p>Any ideas please?</p>
  <p>The query I am using is this:</p>
  <pre><code>INSERT INTO TRANSACTION (TRX_UNIT, TRX_DATE, TRX_USR)
  SELECT SOURCE_SYSTEM_CHANNEL_CODE, TRANSACTION_DATE, USER_CODE
  FROM FCR_TRANSACTION
  WHERE TRANSACTION_DATE = '02-AUG-2006'
  </code></pre>