title: using multiple dates in the IN clause of a sql statement
body: <p>I have function which returns a list of comma seperated dates(e.g. <b>'Dec 24, 2011','Dec 26, 2011','Dec 18, 2011','Dec 27, 2011'</b>.</p>
  
  <p>I am receiving this as a single string.</p>
  
  <p>I want to use this string to build a select query where I want to use the string in the IN clause.</p>
  
  <p>e.g.</p>
  
  <pre><code>select *
  from wfdisplaymgmt
  where programstartdate IN(TO_DATE('Dec 26, 2011','MON dd, yyyy'))
  </code></pre>
  
  <p>Since I am getting a multiple dates I would like to use all the dates in my statement.how can I write the sql query which inlcudes multiple dates.Please help.</p>
  
  <p><B>Update:</b>
  One more thing is I have window with a textbox and a button on clicking the button a sql query is executed.The query returns a distinct number of column values which has an option of selecting each of those values.when the user selects the required values ,the values are copied to the text box(e.g.<b>'Dec 24, 2011','Dec 26, 2011','Dec 18, 2011','Dec 27, 2011'</b> if I have selected four dates).Now the String I want to use this string in a sql statement where I select all the columns of the table based on the selected dates found in the string i.e.values found in the text box.</p>
  
  <p>'Mon DD,YYYY' is the date format returned in the string.</p>
  
  <p>I want a query similar to 
      select *
      from wfdisplaymgmt
      where programstartdate IN(the date values coming from the text box)</p>
  
  <p>how do I do this?</p>