* 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 names; -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
