Re: How to convert strings to 'proper case' ?

2006-05-09 Thread C.R.Vegelin
quot;. The reason for my question was to avoid using MS Access. I will certainly take a closer look at your suggestions ! Regards, Cor - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]>; Sent: Tuesday, May 09, 2

Re: How to convert strings to 'proper case' ?

2006-05-09 Thread Johan Lundqvist
My God! Rhino, that was a very long and very good answer!! Impressive!! /Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to convert strings to 'proper case' ?

2006-05-09 Thread Rhino
fore. But it could be fun too if you are in the right frame of mind! -- Rhino - Original Message - From: "C.R.Vegelin" <[EMAIL PROTECTED]> To: Sent: Tuesday, May 09, 2006 1:41 AM Subject: How to convert strings to 'proper case' ? Hi List, I want to conve

Re: How to convert strings to 'proper case' ?

2006-05-09 Thread Johan Lundqvist
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: Posted by Tom O'Malley on April 18 2006 1:16am An exa

How to convert strings to 'proper case' ?

2006-05-08 Thread C.R.Vegelin
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