Re: SQL Question

["Jim Essinger" <dilbernator@xxxxxxxxx>]

With t1 as(
select substr(oncitm,5,10) cstitm, onitem,okpric    price,
case when okpgrp = '40004' then '1'
   when okpgrp = '40001' then '2' end as Field_Name
 from
vcoitem join vinitem )

 select * from t1 order by Field_name

On Thu, Mar 13, 2008 at 10:12 AM, Jeff Young <cooljeff913@xxxxxxxxx> wrote:

> Given the following SQL Statement -
> select substr(oncitm,5,10) cstitm, onitem,okpric    price,
> case when okpgrp = '40004' then '1'
>    when okpgrp = '40001' then '2' end case
>  from
> vcoitem join vinitem
>
> How can I specify the result of the CASE clause in the order by clause.
> Also, how can I assign a name to the result of the CASE clause
>
> TIA,
>
> Jeff Young
> Sr. Programmer Analyst
> IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
> V5R2
> IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
> Designer V5R3
> IBM  Certified Specialist- e(logo)server i5Series Technical Solutions
> Implementer V5R3
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.