ORDER BY and ignoring the , a , and an

Is it possible to have the ORDER BY option ignore the articles "the ", "a ",
and "an " at the beginning of a VARCHAR, CHAR, TEXT, et cetera field? In
other words, I want my results to come back alphabetized, while ignoring the
aforementioned articles.

Brett Stoppel
Assistant Web Administrator
University of Kansas Academic Computing Services
bstoppel@ku.edu - 785.864.0462 - www.ku.edu