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;
SELECT CONCAT(UCASE(MID(name,1,1)),MID(name,2)) AS name FROM names;
View Full Version : How could I turn the first letter of each entry to Uppercase letter?