I want to retrieve some records that have a specified date (i.e. 07/07/2001). <BR><BR>Select * from widget_table where widget_date = &#039;07/07/2001&#039;<BR><BR>This does not work because the time part of the date/timestamp (I guess) makes the date value greater than 07/07/2001. Is there a wildcard or something I can put in the SQL statement to make this thing work?<BR><BR>Scott