Re: SQL Order Question

> You might be able to achieve what you want using the
> fact that Order By
> sorts false before true, so:
>
>     Order By not(contractid = 'BTS'), contractid ASC
>
> Regards,
> George
>
> ----- Original Message -----
> From: <operationsengineer1@yahoo.com>
> To: <pgsql-novice@postgresql.org>
> Sent: Thursday, May 04, 2006 1:33 PM
> Subject: [NOVICE] 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...

George, you are on the money...  this does it:

SELECT contract_id, contract_number FROM t_contract
ORDER BY not(contract_number = 'BTS'), contract_number
ASC

thanks to all who helped.

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