RE: SQL - Using Case in Order By clause

Definitely an inspired solution!

-rf

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
> bounces@xxxxxxxxxxxx] On Behalf Of THarteau@xxxxxxxxxxxxxxxxxx
> Sent: Wednesday, June 23, 2004 11:41 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL - Using Case in Order By clause
> 
> 
> Hi,
>       Just to finish this up, I concatenated the fields, and it's working
> fine.
> 
> C/EXEC SQL DECLARE A CURSOR FOR
> C+ SELECT EMEMP#,EMPNAM,EMSTCD,EMOHYY,EMCORP,EMPAY#
> C+ FROM HRV6DTA/HRPEMP
> C+ ORDER BY Case  When :F1Sort = 'Y' then EMEMP#
> C+                      When :F1Sort = 'N' then EMLNAM ConCat EMFNAM
> C+                      End
> C/END-EXEC
> 
> 
> <===================================================>
> 
> Terri Harteau
> Felker Brothers Corporation
> ****************
> Paperwork is like kudzu. Both need to be pruned regularly. Usually, a
> flamethrower is overkill.      Usually.
> ****************
> 
> 
> 
> 
> 
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.