* Jari Mäkelä
> How could I turn the first letter of each entry to Uppercase letter?
>
> the UCASE turns each and every letter and all I need is the first
> one to be changed
You can use a combination of UCASE(), MID() and CONCAT():
SELECT CONCAT(UCASE(MID(name,1,1)),MID(name,2)) AS name FROM
application do some of
the legwork, instead of the db.
- Original Message -
From: "Jim Philips" <[EMAIL PROTECTED]>
To: "Jari Mäkelä" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 9:08 AM
Subject: Re: uppercase for first letter
If
If you can't do it within MySQL (I don't know the answer to that one) you
might be able to dump the information to a text file and process it using awk
and then reload it. Awk is perfect for this kind of thing. There is a Windows
version, if that is your OS.
On Wednesday 24 April 2002 08:49 am
sql,query
Hi,
How could I turn the first letter of each entry to Uppercase letter?
the UCASE turns each and every letter and all I need is the first one to be changed
JAri Mäkelä
-
Before posting, please check:
http://w
