RE: Converting names & street names

Is it possible to use UPPER(string) or LOWER(string) or UCASE and LCASE?



 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: 01 September 2006 12:15
To: 'Midrange Systems Technical Discussion'
Subject: RE: Converting names & street names

The only way to get this right is not to lose the mixed-case form in 
the first place.  If it's not feasible just to store the name in 
mixed-case and upper-case it for comparisons

To me, the only reason this data is stored in the database in uppercase
is inertia.  Years and years ago printers could only print uppercase.

For all of you that are smarter than me:

Suppose I decide I'm going to just store the data in the database in
mixed-case form.  What are the ramifications?  Will sorts and OPNQRYF
and SQL still _sequence_ them in true alphabetical order?  I understand
that comparisons for include/equal/etc need to be altered as "Joe" and
"JOE" will not compare equal.  What other kinds of thing are there?

As long as Midrange-L has been here and as often as other topics have
repeated themselves ad nauseum, I'm rather amazed we haven't hashed this
out before.  'Course I lose brain cells on a monthly basis . . .

--
Jeff Crosby
Dilgard Frozen Foods, Inc.
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531

The opinions expressed are my own and not necessarily the opinion of my
company.  Unless I say so.


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