|
|
||||||
|
#1
07-24-08, 11:51 PM
|
|
|
|
|
UPDATE `table` SET target_field = CONCAT(UCASE(SUBSTRING(`source_field`, 1,
1)),LOWER(SUBSTRING(`source_field`, 2))) |
|
|
|
#2
07-25-08, 01:48 AM
|
|
|
|
|
GO AWAY IMPOSTOR, JUST FYI!
"kevpan815's Psychiatrist" <kevpan815> wrote in message news:8546 [..] |
|
#3
11-05-08, 04:18 AM
|
|
|
|
|
That only does the first word. I wrote a little function to do it :
'MySQL Capitalize Function' (http://joezack.com/index.php/2008/10...lize-function/) |
|
|
| Similar Threads | |
| wants to capitalize the first letter in the first word of every li I have even turned off the "capitalize first word of sentence" to try to get rid of this but it is still following me around. There is a green sawtooth line under the first... |
|
| Capitalize the first letter in each word Hi, I created a report from the table that imported from the internet. Somehow all the patient names are capitalized. Ex: SUE TRAN In my report, I would like the patient's... |
|
| Function using exceptions to capitalize first letter of each word Does anyone have any suggestions on how to make the following function do the followign: 1. Capitalize every word except those in an exceptions list. 2. Always capitalize... |
|
| How do I use VB to capitalize the first letter in a word? How do I create a procedure to convert a field values to proper case? (Capitalize the first letter of each word, and convert all others to lower case) I.E. Nova Scotia,... |
|
|
All times are GMT. The time now is 07:07 AM. | Privacy Policy
|
Capitalize the first letter of each word using MYSQL