Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select statement that makes all chars after the first char lower case?
Example:
Current: AARON
After: Aaron
I think this is possible.. just don't know how to execute the
SELECT CONCAT( UPPER( LEFT( first, 1 ) ), LOWER( RIGHT( first, LENGTH(
first ) - 1 ) ) ) AS `first` FROM table
On Jul 13, 2004, at 12:51 PM, Aaron Wolski wrote:
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select
Furgiuele [mailto:[EMAIL PROTECTED]
Sent: July 13, 2004 1:10 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: all upper case records.. Keeping first char upper and
rest
lower?
SELECT CONCAT( UPPER( LEFT( first, 1 ) ), LOWER( RIGHT( first, LENGTH(
first ) - 1 ) ) ) AS `first` FROM
It's ulgy, and I'm not sure how efficient it is, but this will do the trick:
select concat(left(first,1),substring(lower(first) from 2)) as first;
Aaron Wolski wrote:
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select