to change the first letters of a single column to capital

Answer 1

select concat(upper(mid(columnchange,1,1)),mid(columnchange,2)) from thetable

Answer 2

select concat(upper(substr(column,1,1)), substr(column,2)) from table

Answer 3

SELECT CONCAT(UPPER(LEFT(column,1)),RIGHT(column,LENGTH(column)-1)) FROM table