Answers for "first letter capital in sql query"

SQL
2

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)
Posted by: Guest on September-01-2020
-1

how to get capital letter first in sql

INITCAP retrieves capital letter first
Posted by: Guest on January-28-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language