SQL Order Question - Mailing list pgsql-novice

From
Subject SQL Order Question
Date
Msg-id 20060504183333.88479.qmail@web33314.mail.mud.yahoo.com
Whole thread Raw
Responses Re: SQL Order Question
Re: SQL Order Question
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Efficiency of indexes on CHAR(n) and VARCHAR(n)
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: SQL Order Question