Hi Cor,
Don't know if that function exists in MySQL...
If you by any chance is using PHP you can do it by using ucfirst(str)
But I quote the User Comment at
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html from Tom
O'Malley:
<quote>
Posted by Tom O'Malley on April 18 2006 1:16am
An example of how to make the first letter in a string uppercase -
analogous to UCFIRST
SELECT CONCAT(UPPER(SUBSTRING(firstName, 1, 1)),
LOWER(SUBSTRING(firstName FROM 2))) AS properFirstName
</quote>
/Johan
C.R.Vegelin wrote:
Hi List,
I want to convert strings to proper-case,
where only the 1st char of each word is uppercase,
such as: "This Is An Example."
Any idea how to do this with MySQL 5.0.15 ?
Thanks, Cor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
