SQL programming question

What option do I put in an SQL statement to order the results alphabetically by a certain field? __________________ Nevermind, I found it. Thanks. __________________ ORDERBY heehee actually I just learned SQL this summer and this site helped me get started http://w3.one.net/~jhoffman/sqltut.h...+SQL+Questions It does not have the advanced stuff but it should be good enough for simple stuff. I was able to use it with combination of other things to make very complex joins and situations. __________________ Maggie seems to be working really hard this summer... First ASP and now SQL Maybe I shouldn't come to this site that often __________________ hehe MaggieOK, if you need help on SQL commands shoot me an email or post something. I will try to help if you can. As for ASP though I want to learn it still =P __________________ Hehehe, working hard yes, but just tweaking stuff I hired out. I don't have the time to create my own stuff (if I even knew how). I appreciate the offer of help, I may take you up on it if I have other questions. Thanks!