capitalize 1st letter in sql server

Solutions on MaxInterview for capitalize 1st letter in sql server by the best coders in the world

Search
showing results for - "capitalize 1st letter in sql server"
Marta
22 Jul 2018
1mysql> Select CONCAT(UPPER(SUBSTRING(name,1,1)),LOWER(SUBSTRING(name,2))) AS Name from emp_tbl;
2+----------------+
3| Name           |
4+----------------+
5| Rahul singh    |
6| Gaurav kumar   |
7| Yashpal sharma |
8| Krishan kumar  |
9| Kuldeep rai    |
10| Munish nayak   |
11+----------------+
126 rows in set (0.00 sec)
source
similar questions
get first 2 letter in sqlsql first charactermssql to uppersql server case sensitive searchfirst letter capital in mysql querytsql table column constraint must be uppercasequery only first letter stringoracle first letter uppercaseinitcap in sqlupper case sqlfunktion lower 2fupper sqloracle sql query to make column data uppercasesql server to uppercasehow to get capital letter first in sqlhow to make case insensitive in sqluppercase sqlget all name uppercase in sqlhow to upper case in sqluppercase and lowercase in sqlhow to write uppercase in sqlcase insensitive sqlget first 3 letters name in sqlget first 3 letters in sql
queries leading to this page
uppercase first letter sqlsql capitalise first letterfisrt letter uppercase sqlsql uppercase first lettersql first letter uppercasesql to upper first charactersql string extract first letter capitalfirst letter uppercase in one collumn sqlcapitalize first character in sql1st letter capital in sqlsql set first letter uppercasesql server capitalize first letterms sql capitalize first lettersql server capitalize stringupper first letter in sql serversql string functions uppercase first lettersql to capitalize first letterhow to convert first letter of string to uppercase in sqlupper only first letter sqlsql capitalize first lettersql server first letter capitalcapitalize first letter of sql servesql first letter capital of wordcapital all letters sqlservercapitalize first letter when each word is capital in sql serverupper 1st letter sqlcapitalize 1st letter in sql server