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:
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
the 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 you can't do it within MySQL (I don't know
* 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
