I am trying to SELECT a set of records from a table where the date equals a certain date.<BR><BR>When I put the following it returns no results in SQL.<BR><BR>SELECT * from schedular WHERE date = 16-04-2001<BR><BR>I am putting this string in Enterprise manager, I have not tried it on my ASP page yet. Why does it show no records? I clearly have several on that selected date.<BR><BR>If I do a select by accountno which is another column in the table then the correct results are returned.<BR><BR>Help would be appreciated!<BR><BR>Thanks<BR>*W