SQL Order Question

hi all,

i want to order contract numbers id ascending order,
with the exception of 'BTS' that I want to display
first.  the contract numbers are numeric and 'BTS' is
text.  the numeric values come first when i sort in
asc order - as expected.  how can i get BTS (id = 0)
to come up as the first value in my query?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com