Hi, In asp when you do a Select statement - is there anyway to have it ORDER BY specific words in a column? In the class column it says Open or Close or Suspended. With a Select statement can I tell it to ORDER BY Class - Open then Close then Suspended? Jess