Re: Order By Problem

[Jennifer Tran <jtran@BMS.CALSTATE.EDU>]

Looking at the available criteria which can be used to perform the search, they
are not unique enough nor appear to be in any possible order. You might need to
define additional sort criteria as follow:  "safety =  1, safety critical = 2,
shutdown = 3...and so on" and then you'll be able to sort them using the value
1, 2, 3,.. hope this'll work...

"Benzenhafer, Dave" wrote:

> Below you can see the other field associated with the number code. I need to
> Order By on this Criticality field. I hope this helps to explain.
>
> As is               I need it to order by like this
> 10489 Shutdown            10492 Safety
> 10490 Critical            12473 Safety Critical
> 10491 Normal              10489 Shutdown
> 10492 Safety              12553 Op Critical
> 12473 Safety Critical     10490 Critical
> 12474 Operational Std     12474 Operational Std
> 12475 On Request          10491 Normal
> 12553 Op Critical         12475 On Request
>
> Dave Benzenhafer
>
> -----Original Message-----
> From: Rick_Creel@AONCONS.COM [mailto:Rick_Creel@AONCONS.COM]
> Sent: Thursday, February 22, 2001 12:26 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: Order By Problem
>
> 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

--
*********************************
California State University
       -----------
        Jennifer Tran
Email: jtran@bms.calstate.edu
Phone: (562)951-4395

 Making everyday a better day
*********************************