Is there any way of changing only the first letter to upper case? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

Is there any way of changing only the first letter to upper case?

Upper case

1st Sep 2016, 3:00 PM
Ananya Ojha
Ananya Ojha - avatar
4 Answers
+ 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;
1st Sep 2016, 6:05 PM
waqim aziz
waqim aziz - avatar
+ 14
example: select initcap(name) from emp ;
2nd Sep 2016, 5:54 AM
sangamesh naikar
sangamesh naikar - avatar
+ 7
using initcap() function you can make first letter to upper case
2nd Sep 2016, 5:53 AM
sangamesh naikar
sangamesh naikar - avatar
+ 2
yeah use inticap function
16th Dec 2016, 5:26 AM
Rincy Pereira
Rincy Pereira - avatar