SQL="SELECT CD FROM Store WHERE Purchase_Date LIKE #"&newtime&"%#"<BR>Now here's the problem. My field Purchase_Date is a FULL date/time, meaning 9/18/00 4:45 PM. My newtime field is just a regular short date-9/18/00. I want to select the CD only where the dates match. However being that the two fields are different, I am trying to add a wildcard character (%) to the newtime. But no matter where or how, I try to put it there, it's just not in the right place. Can it be done- a wildcard with a date? What am I missing here?