RE: order by rrn, or lifo?

I thought the exact same thing!!!  

You know, you ask one question, and you get 2 great solutions...  

tim

> -----Original Message-----
> From: Metz, Zak [SMTP:Zak_Metz@xxxxxx]
> Sent: Thursday, August 07, 2003 9:36 AM
> To:   Midrange Systems Technical Discussion
> Subject:      RE: order by rrn, or lifo?
> 
> How on earth have I gotten by this long without knowing I could do
> "filename.*"??? Thank you, thank you, thank you, Steve...I've already
> used it today! And that, my friends, is why I read these lists...
> 
> > -----Original Message-----
> > From: Steve Landess
> > 
> > Try something like this:
> > 
> >   select rrn(filename),filename.*
> >   from filename
> >   order by 1 desc
> NOTICE: This E-mail may contain confidential information. If you are not
> the addressee or the intended recipient please do not read this E-mail
> and please immediately delete this e-mail message and any attachments
> from your workstation or network mail system. If you are the addressee
> or the intended recipient and you save or print a copy of this E-mail,
> please place it in an appropriate file, depending on whether
> confidential information is contained in the message.
> 
> 
> _______________________________________________
> 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.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.