[RESOLVED] SQl query

Hi
I have an SQL server 2000 table that has a field called "Files".
I execute the following query:
Rs.open"Select Files from Books where BDate like ' &sdate1 & "'",cnn,adopenStatic,adlockoptimistic
it returned the following recordset
01daily.doc
05daily.pdf
04daily.doc
19daily.doc
16daily.doc

Now i want to select the record whose Files value begins with the highest number,in this case
it's 19daily.doc

how can i do it?
thanks in advance

Try this :

VB Code:

Rs.open"Select Files from Books where BDate like '" &sdate1 & "' order by Files desc",cnn,adopenStatic,adlockoptimistic

.. or if you JUST want the highest value, then :

VB Code:

Rs.open"Select max(Files) from Books where BDate like ' & sdate1 & "'",cnn,adopenStatic,adlockoptimistic

thanks the BionicOrange