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