| From: | <operationsengineer1(at)yahoo(dot)com> |
|---|---|
| To: | Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: SQL Order Question |
| Date: | 2006-05-04 19:34:15 |
| Message-ID: | 20060504193415.32110.qmail@web33304.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> On 5/5/06, operationsengineer1(at)yahoo(dot)com
> <operationsengineer1(at)yahoo(dot)com> wrote:
> > 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?
> I'm not sure I fully understand the structure of
> your
> data ... do BTS and the numeric contract numbers
> appear in the same column?
>
yes.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2006-05-04 19:40:11 | Re: SQL Order Question |
| Previous Message | Andrej Ricnik-Bay | 2006-05-04 18:39:08 | Re: SQL Order Question |