0

to change the first letters of a single column to capital

24th Oct 2016, 4:35 PM
kavitha
3 odpowiedzi
0
select concat(upper(mid(columnchange,1,1)),mid(columnchange,2)) from thetable
24th Oct 2016, 10:44 PM
Jose Baca
Jose Baca - avatar
0
select concat(upper(substr(column,1,1)), substr(column,2)) from table
26th Oct 2016, 4:13 PM
ArchiC
0
SELECT CONCAT(UPPER(LEFT(column,1)),RIGHT(column,LENGTH(column)-1)) FROM table
30th Oct 2016, 12:41 AM
Peter