/SQL/How to get capital letter first in sql

How to get capital letter first in sql

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

How to get capital letter first in sql

INITCAP retrieves capital letter first

Similar codes

0 vote157 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
15 votes159 views2 answers
Select Options
SQL
0 vote168 views1 answer
Test sql query
SQL
0 vote149 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote161 views1 answer
Get db connection detail from sql developer profile
SQL
16 votes210 views4 answers
Find duplicates mysql
SQL
-3 votes149 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
4 votes146 views3 answers
Order by value mysql
SQL
-1 vote163 views2 answers
Mysql get day of week
SQL
0 vote163 views1 answer
Product of a column in mysql
SQL