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.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Sivan Rabinovitz [SMTP:[EMAIL PROTECTED]]
Do you know initcap function?
SELECT INITCAP('the soap') "Capitals" FROM DUAL;
Capitals
---------
The Soap