selecting from table using MAX

I'm using ms sql 2k, and I'm trying to select the most recent entry into my database. Since each entry has a "RecordID" field that increments up with each entry, I was thinking I could use MAX to select the most recent entry. However, I'm having trouble implementing this. When I try , I obviously get only the RecordID field, without the rest of the entry. If I do something like I get nothing. There is a field which contains the date and time of submission, but it is in char format, and contains both date and time in one field, so I don't know how I'd search that effectively. The best and most unique of the fields is the RecordID field, so does anyone know how I can get this MAX thing to work? Thanks a lot

You might try just ordering the items by RecordID and then sorting in descending order and getting the first element. I don't use MS SQL, but in postgres it would be something like:

SELECT * FROM "UserAccess" ORDER BY RecordID DESC LIMIT 1

The syntax may be a little bit different in MS SQL, but there should be something very similar.

HTH
-b

Thanks Bcyde, that put me on the right track. In case anyone else needs to do something similar, my final working query was Sorts in decending order, and picks the top record. Again, thanks for the help