ience.
-- Philip
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 11, 2002 9:38 PM
I just had a heated, well perhaps not heated, but certainly adversarial
discussion with my manager regarding mixed case text. My
Title: RE: mixed case text
SELECT INITCAP('mccoy') "McCoy" FROM DUAL;
McCoy
-
Mccoy
Better hope your name isn't Hatfield!
(Alluding to the famous Hatfield-McCoy feud in the USA a few years ago).
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc
sday, September 11, 2002 9:38 PM
I just had a heated, well perhaps not heated, but certainly adversarial
discussion with my manager regarding mixed case text. My position...Keep it
out of the database. His position ...same case text looks amateurish when
output, and the database should readil
The initcap function can work pretty well in a lot of cases but those
exceptions can be major. I remember there being discussions on this
list about how does one handle names starting with Mc or Mac. At the
time the original post came in I was dealing with some strings that
included the degrees MD
ptember 11, 2002 9:38 PM
I just had a heated, well perhaps not heated, but certainly adversarial
discussion with my manager regarding mixed case text. My position...Keep it
out of the database. His position ...same case text looks amateurish when
output, and the database should readilly accomodate i
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
xperience.
-- Philip
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 11, 2002 9:38 PM
I just had a heated, well perhaps not heated, but certainly adversarial
discussion with my manager regarding mixed case text. My
to do
that in Clipper 12 years ago".
It is my opinion that if you want to output mixed case data you should use
functions to "beautify" text like names and addresses. My biggest objection
is that by allowing mixed case text in a table, you are setting up
developers (and me) to write qu
I just had a heated, well perhaps not heated, but certainly adversarial
discussion with my manager regarding mixed case text. My position...Keep it
out of the database. His position ...same case text looks amateurish when
output, and the database should readilly accomodate it. He almost seems