Sivan Rabinovitz[SMTP:[EMAIL PROTECTED]] wrote:
> >Do you know initcap function?
> >
> >
> >SELECT INITCAP('the soap') "Capitals" FROM DUAL;
> >
> >Capitals
> >---------
> >The Soap
>
OK, how about Jaap van der Meer. Or any of a thousand other real-world
names that people, places and events have. Bottom line is the db is there
to serve the user, and when it comes to text, it's not the db's job to
insist on an out-of-date quirk of 20+ year old systems, or tell humans to
change the way they communicate. Store it twice( the second in all-upper),
or use function-based indexes, to get the back end to behave. Don't force
the users to deal with Oracle's case-sensitive limitations.
(Sorry Sivan, this rant isn't really aimed at you - just one of my pet
peeves)
Just my 2�
Ciao
Fuzzy
:-)
----------------------------------------------------------------------
"Woo Hoo!" - H. Simpson
----------------------------------------------------------------------
The contents of this post are my opinions only
If swallowed seek medical advice
(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to
TOWER Software. If you are not the intended recipient you cannot use,
distribute or copy the message or message attachments. If you are not the
intended recipient, please notify the sender by return email immediately and
delete all copies of the message and attachments. Opinions, conclusions and
other information in this message and attachments that do not relate to the
official business of TOWER Software, are not given or endorsed by it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grant Allen
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
