Hi there, Thanks for the help!
Someone else also gave me a similar query which did exactly as yours did. But with the same minor problem In this table.. I also have columns for last and email. So the columns are first,last,email. The problem with both yours and this other person's query is that is groups all the columns (first,last,email) into one column. What I would like is just the 'first' column. Something tells me this isn't possible? Thanks to you as well for the help. I wouldn't have figured it out for myself that's for sure. Aaron > -----Original Message----- > From: Wesley 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 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 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 functions > > together to make it happen. > > > > Thanks! > > > > Aaron > > > > > > > > -- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
