/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 vote303 views1 answer
How to print some string in mysql
SQL
0 vote269 views1 answer
Oracle execute immediate quotes
SQL
0 vote310 views1 answer
Oracle list datafiles
SQL
2 votes311 views2 answers
Create empty table from existing table
SQL
1 vote311 views3 answers
How to create a table structure from another table in mysql
SQL
7 votes286 views2 answers
Mysql db size
SQL
0 vote294 views1 answer
Get who is hired in month in sql
SQL
0 vote300 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote237 views1 answer
Calculate discount from original price sql
SQL
8 votes263 views3 answers
Duplicate entry
SQL