Hi. I'm a sorta novice ASP programmer, so I sure could use some help\nfrom of you more experienced gurus....\n\nI've written an ASP page that pulls all records from a table. My query\nis 'SELECT * FROM teacher ORDER by Class'\n\nIt is working fine... sorta. The table has about 20 records, but only\n5 have an entry in the 'Class' field. The 15 records with the blank\nclass field show up first, then the other 5 records. Is it possible to\nhave the blank one show after the ones with an entry. Here's how my\nresults look, IOW.\n\nThe 15 blank\n3A\n3B\n5B\n6A\n7D\n\nI would like it to show as:\n\n3A\n3B\n5B\n6A\n7D\nThe 15 blank\n\nI tried using the DESC keyword, but as I imagined, the results were:\n\n7D\n6A\n5B\n3B\n3A\nThe 15 blank\n\nSo, can anyone help me out here? I hope I've made everything clear\nenough.