I need to format strings like:
Code:
this string needs to be each first letter capitalized
/* to */
This String Needs To Be Each First Letter Capitalized
I had already done that
Code:
SELECT
CONCAT(
UPPER(SUBSTRING("string to capitalize", 1, 1)),
LOWER(SUBSTRING("string to capitalize", 2,
CHAR_LENGTH("string2capitalize"))
)
) AS "Capitalized"
+----------------------+
| Capitalized |
+----------------------+
| String to capitalize |
| |
+----------------------+
But it capitalizes only the first letter of the string
dBforums
>
Capitalize First Letter of Each Word
01-12-06, 04:03
Capitalize First Letter of Each Word
Linear Mode
