/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

1 vote161 views1 answer
Set statiscis on in ssms
SQL
3 votes199 views2 answers
How to View column names of a table in SQL
SQL
0 vote161 views1 answer
Mysql not defined
SQL
1 vote178 views1 answer
Mysql update inner
SQL
0 vote146 views1 answer
Sql clear table
SQL
0 vote149 views1 answer
Show size of all tables postgres
SQL
5 votes191 views1 answer
Purge undo tablespace usage
SQL
11 votes145 views4 answers
MYSQL LOGIN
SQL
0 vote146 views1 answer
View acl table oracle
SQL
0 vote158 views1 answer
Postgresql comandos basicos
SQL