Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by www.tutorialspoint.com #
 
PREVIOUS NEXT
Tagged: #capitalize #letter #sql #server
ADD COMMENT
Topic
Name
3+5 =