/SQL/Capitalize 1st letter in sql server

Capitalize 1st letter in sql server

mysql> Select CONCAT(UPPER(SUBSTRING(name,1,1)),LOWER(SUBSTRING(name,2))) AS Name from emp_tbl;
+----------------+
| Name           |
+----------------+
| Rahul singh    |
| Gaurav kumar   |
| Yashpal sharma |
| Krishan kumar  |
| Kuldeep rai    |
| Munish nayak   |
+----------------+
6 rows in set (0.00 sec)

Source: tutorialspoint.com

Similar codes

0 vote108 views1 answer
Datagrip go to line
SQL
0 vote106 views1 answer
Mysql database hyphen
SQL
0 vote106 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote105 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote110 views1 answer
Oracle current session details
SQL
1 vote110 views3 answers
What is union in sql
SQL
1 vote100 views1 answer
How to start with sql
SQL
1 vote127 views1 answer
Insert pg result of select
SQL
23 votes102 views6 answers
How to create table in sql
SQL
0 vote108 views1 answer
Nueva tabla mysql
SQL