/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 vote280 views1 answer
Postgresql certain first 4 characters in string
SQL
13 votes280 views2 answers
Sql count distinct group by
SQL
0 vote287 views1 answer
Compare two tables to find unmatched records
SQL
0 vote290 views1 answer
Enable sql server full text indexing
SQL
2 votes280 views1 answer
How to create sql database
SQL
1 vote242 views1 answer
Database run
SQL
0 vote269 views2 answers
Database owner can't create new tables postgres
SQL
5 votes303 views1 answer
Sql integer to serial
SQL
0 vote290 views1 answer
Postrgres trunc
SQL
0 vote285 views2 answers
Collation in sql
SQL