Aaron, How about something like :
SELECT CONCAT(UCASE(LEFT(FieldName, 1)), LCASE(RIGHT(FieldName,LENGTH(FieldName)-1))) Right out of my head, I didn't count all the parantheses :-) Freddie > -----Ursprüngliche Nachricht----- > Von: Aaron Wolski [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 30. Juni 2004 18:46 > An: [EMAIL PROTECTED] > Betreff: making lower case then first char to upper case? > > Hi Guys, > > I'm trying to figure out of this is possible. I know I could > do it in PHP but I am dealing with a ton of records and would > rather put the processing on the DB than PHP/client side. > > Question is. can I do a SELECT query on a column that changes > all the results to lower case and THEN changes the first > character of each result to an upper case? > > Example: > > Currently in DB: AARON > to Lowercase: aaron > to Uppercase: Aaron > > > Any idea on if I can do this and how I might approach it? > > Thanks so much > > Aaron > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
