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