OTECTED]>
Sent: Friday, April 26, 2002 8:24 AM
Subject: RE: Uppercase first letter of each word
> this is for php, if you are not using php then try something similar
>
> //use explode to create an array with one word in each item
> $sql_array = explode(" &quo
Hi,
A function like initcap in other databases and programming languages in
mysql would be
much desired in such situations.
You may try this ugly code.
select ltrim(replace(replace(replace...(concat(' ',lower(strcolumn)),' a','
A'),' b',' B' ),' c',' C'), ...,' z',' Z')) from tablename;
A
-Original Message-
> From: Doug Bishop [mailto:[EMAIL PROTECTED]]
> Sent: 26 April 2002 05:10
> To: [EMAIL PROTECTED]
> Subject: RE: Uppercase first letter of each word
>
>
> I have no problem with figuring out how to punctuate a field that
> contains a
> single w
I have no problem with figuring out how to punctuate a field that contains a
single word, but how would I code a SQL query to proper-case each word in a
field when the field contains, for instance, a title? I want to convert,
"HOW NOW BROWN COW" to, "How Now Brown Cow"
Thanks,
Doug