> On 5/5/06, operationsengineer1@yahoo.com
> <operationsengineer1@yahoo.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