SQL Order Question

From: <operationsengineer1(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: SQL Order Question
Date: 2006-05-04 18:33:33
Message-ID: 20060504183333.88479.qmail@web33314.mail.mud.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2006-05-04 18:39:08 Re: SQL Order Question
Previous Message Sean Davis 2006-05-04 17:14:27 Re: Efficiency of indexes on CHAR(n) and VARCHAR(n)