• Subject: RE: Attention English Majors?
  • From: Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>
  • Date: Thu, 4 Nov 1999 15:35:10 -0800

I was a history major and, consequently, know only one trick in this area.
Only works for Query400.

On the "Select Collating Sequence" screen choose option 5, "System Sort
Sequence."  When you press ENTER you'll be taken to a screen that asks you
to choose the system sort sequence.  Choose option 3, "Shared."  This will
give you a case insensitive sort in queries.  

I'd love to hear something for programs that was better (easier) than
shadowing mixed case data with work fields translated to uniform case and
sorting using the work fields.

> -----Original Message-----
> From: Bob Randall [mailto:BLR@airxcel.com]
> Sent: Thursday, November 04, 1999 8:54 AM
> To: MIDRANGE-L@midrange.com
> Subject: Attention English Majors?
> OK, some of the people around here are trying to enter the 
> 20th century (we
> are not worried about the 21st century yet <grin>).Anyway, we 
> are starting
> to use some lower case data for proper capitalization. They 
> are used to
> being all caps for everything. Some of you have already surmised the
> problem. In standard hexadecimal, lower case letters all sort 
> ahead of upper
> case. Is there a really simple answer to make lower case sort 
> equal to upper
> case? I know I can use a lot of ALTSEQ statements, but it 
> seems there should
> be an easier way to handle this for all system sorts and 
> such. Could an
> AS/400 English Major (or not an English Major) help with this?
> TIA,
> Bob Randall
> Airxcel, Inc.
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].