Log in

View Full Version : How could I turn the first letter of each entry to Uppercase letter?


Hallam
2015-03-31, 09:28 AM
You can use a combination of UCASE(), MID() and CONCAT():

SELECT CONCAT(UCASE(MID(name,1,1)),MID(name,2)) AS name FROM names;