Even better than Bob's answer would be: select * from table where date is (select max(date) from table) order by time desc Also, you might want to try ASPLISTS.com in the future as well. . .they have special lists for queries in ASP, ASP Databases, etc. . . .real helpful (not arrogant) help on there - very experienced developers. (Not that the people on this list aren't great too. . . ;-)) http://www.asplists.com/asplists/aspfreeforall.asp HTH, Don -----Original Message----- From: Bob Davis [mailto:bobd at members.evolt.org] Sent: Tuesday, April 10, 2001 11:12 AM To: thelist at lists.evolt.org Subject: Re: [thelist] ASP & SQL SELECT Query - comparing dates Hi Elfur! On Tuesday, April 10, 2001, at 11:08 AM, Elfur Logadottir wrote: > strSQL2 ="select * from table where date like " & strSQL & " order by > time desc" > > but no such luck. > how do I have to do this? You could try a sub query. select * from table where date is (select TOP 1 date from table) order by time desc NB: I haven't tested this, and it's been a little while since I did any sql work, so it might not be 100% correct... bob -- bob davis bobd at members.evolt.org --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !