SELECT * FROM table ORDER BY table; that seems to do the trick for me when I need to order things alphabeticly. Mike ----- Original Message ----- From: "abe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 09, 2000 10:15 AM Subject: [GENERAL] ORDERING alphabetically > Hi there, > > Does anyone know how to get results from a query in alphabetical order (for one > field such as surname). I skimmed over the documentation and no luck. > > The field type for surname is varchar - Maybe this is why order by didn't work. > > Thankyou, > Abe >
