Sql

Search

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)

Comment

how to get capital letter first in sql

INITCAP retrieves capital letter first

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql output parameters
Sql :: mysql get auto_increment value
Sql :: mysql workbench primary key
Sql :: desc sql
Sql :: mysql replace empty string with null
Sql :: float vs decimal sql
Sql :: group by sql
Sql :: union sql
Sql :: ranking functions in sql
Sql :: sql query interview questions githu
Sql :: is firebase nosql
Sql :: sql and or
Sql :: Create table if not exist with exceptions
Sql :: left join
Sql :: postgres duplicate database in same server while other session is using source database
Sql :: increase space oracle aws instance
Sql :: how to use 3 fields as primary key in sql tables?
Sql :: query builder doctrien return sql
Sql :: SQL MAX() and MIN() with Strings
Sql :: sql countif
Sql :: sqlalchemy core in clause
Sql :: SQL Primary Key single column
Sql :: basic structure of sql expression having clause
Sql :: sql Contain declare sample
Sql :: multiple like values for single column postgres
Sql :: postgres add column at position
Sql :: what is unsigned mysql
Sql :: oracle procedure chain step
Sql :: Uncomment listen_address=localhost
Sql :: oracle timestamp +1h

Search

SQL

capitalize 1st letter in sql server

how to get capital letter first in sql

ADD CONTENT