Re: Order By Problem

[Rick_Creel@AONCONS.COM]

What kind of order are you wanting?  What you want looks like random order to
me.  Are there any other fields that help determine the order?





"Benzenhafer, Dave" <DBenzenhafer@DEEPWATER.COM> on 02/22/2001 01:06:37 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  Order By Problem



I have a number field that I would like to change the sort order by without
creating another table to sort by if possible. Not all of the numbers show
up in every report. The Table the field comes from looks like this.

As is           I need it to order by like this
10489                   10492
10490                   12473
10491                   10489
10492                   12553
12473                   10490
12474                   12474
12475                   10491
12553                   12475

I have tried instr() without much success. Is it possible to use something
like the instr() function to change the sort order of a field.

Thank You in advance for you help and time.
Dave Benzenhafer