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 :: Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.
Sql :: how to connect mysql with specify port thorugh cmd
Sql :: check mysql version phpmyadmin
Sql :: how to use a trigger to validate input data
Sql :: sql server user permissions and roles
Sql :: mysql cli connect with password
Sql :: psql: error: FATAL: role "postgres" does not exist
Sql :: oracle pl/sql prevent sql injection
Sql :: change name of colum in sql table
Sql :: create table with primary key auto increment in sql
Sql :: update data with random values postgres
Sql :: list columns in table postgres
Sql :: mysql find and replace
Sql :: mysql best varchar length size
Sql :: oracle list service names
Sql :: What is localhost IP and MySql default port no.
Sql :: sql fillna
Sql :: mysql login console
Sql :: postgres alter table add column with default value
Sql :: mysql all columns
Sql :: postgres first_value in gropby
Sql :: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
Sql :: how to find column in all the tables sql
Sql :: mysql convert column to uppercase
Sql :: mysql to lowercase
Sql :: mysql remove only_full_group_by permanently
Sql :: ajouter une clé etrangere mysql
Sql :: mysql size of table
Sql :: sql server arabic collation
Sql :: mysql concatenate select results

Search

SQL

capitalize 1st letter in sql server

how to get capital letter first in sql

ADD CONTENT