+ 2
Is there any way of changing only the first letter to upper case?
Upper case
4 Antworten
+ 14
yes, use the combination of concat() and substr().
SELECT CONCAT(UPPER(Substr(column_name, 1, 1)), LOWER(Substr(column_name, 2, length(column_name))))
FROM table;
+ 14
example: select initcap(name) from emp ;
+ 7
using initcap() function you can make first letter to upper case
+ 2
yeah use inticap function