RE: Attention English Majors?

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
+---