/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 vote268 views1 answer
Group_concat only returns one row
SQL
26 votes275 views2 answers
Mysql workbench download
SQL
1 vote263 views2 answers
Rebuild index sql server
SQL
4 votes273 views1 answer
SQL find text in SP
SQL
4 votes272 views3 answers
Drop Table Oracle
SQL
0 vote288 views1 answer
How to find lowest in sql
SQL
4 votes272 views1 answer
T-sql get duplicate rows
SQL
0 vote270 views1 answer
List mysql tables and views
SQL
-1 vote276 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote280 views1 answer
Postgresql define pk sequence next number
SQL