On Thu, May 04, 2006 at 13:11:51 -0700,
operationsengineer1@yahoo.com wrote:
>
> almost, but not quite. if i use an order by, it
> orders the entire output, not just the results of the
> 2nd select - so i'm back where i started. that is,
> unless i'mmissing a piece to this puzzle.
You need to order by column <> 'BTS', column converted to a number
Doing the column to a number part is a bit tricky, but can be done
with case as I mentioned previously.