AW: Defining a Custom Sort Order in SQL

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

May be you simply have to make clear how the SELECT-Statement looks like:
1. Su

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Mike
Gesendet: Tuesday, May 29, 2007 22:16
An: RPG programming on the AS400 / iSeries
Betreff: Re: Defining a Custom Sort Order in SQL


I usually try to otherwise I won't find the solution when run into the same
problem again. :-)

On 5/29/07, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:
> Yes - the ORDER BY was inside a subquery.
>
> A request to anyone who gets an answer to their question - please 
> don't leave it as an exercise for us overworked folks to figure out 
> from code what the answer is - help us by putting in a few words - 
> much appreciated, seriously. And this is not meant to dump on anyone - 
> just that it happens so often that someone says, I found the answer, 
> thanks. End of story - no clue as to what that answer was.
>
> Of course, not thinking is something I always try to do!!
>
> Regards
> Vern