how to get capital letter first in sql

Solutions on MaxInterview for how to get capital letter first in sql by the best coders in the world

Search
showing results for - "how to get capital letter first in sql"
Katherine
02 Feb 2019
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
Viktoria
01 Feb 2017
1INITCAP retrieves capital letter first
similar questions
oracle sql query to make column data uppercaseget all name uppercase in sqloracle first letter uppercasehow to make case insensitive in sqlget first 2 letter in sqlquery only first letter stringsql first characterfunktion lower 2fupper sqluppercase and lowercase in sqlhow to write lowercase in sqlfirst letter capital in mysql queryhow to write uppercase in sqluppercase sqlget first 3 letters name in sqlget first 3 letters in sqlcase insensitive sqltsql table column constraint must be uppercaseget first n letter of department name in sqlupper case sqlsql server to uppercaseinitcap in sqlhow to upper case in sql
queries leading to this page
sql server uppercase first letter of each wordsql string extract first letter capitalt sql first letter uppercasesql search for word with first letter capitalupper first letter in sql serversql capitalize first five characterssql select uppercase first lettersql upper first letterget capital char sqldisplaying 1st character in capital in sqlhow to get first character upper in sqlms sql capitalize first letterupper 1st letter sqlfirst letter upper case in sqlhow to capitalize first letter of each word in sql serversql first letter uppercase all worduppercase first letter sql in columnshould i always use capital in sqlsql capitalise first lettersql first letter only in uppersql server first uppesql attributes that start with capital lettersmssql firstletter uppercaseuppercase first letter of word in sqlsearch by first letter capital sql likeall sql syntax starts with capital lettersql find capital letterscapitalize first character in sqlhow to make first letter capital in sqlfirst letter uppercase and the rest lowercase in sqlsql to capitalize first letterdo i need capital letters sqluppercase first letter orcacle sqlsql lowercase first letterfirst letter capital only in sql select sataemtnsql set first letter uppercasehow to set uppercase sql query table first letterfirst letter capitalize sqlsql select capitalize first lettermssql first letter in stromg upper casesql to upper first charactersql server make a alphabet as capitalname first letter capital in sql querysql first letter capital of wordmssql capitalize first lettersql string function to capitalize first lettersql where capital letterscheck if first letter is capital sqlsql string functions uppercase first letterfirst letter capital in sql1st letter capital in sqlget capital word sqlsql server string function to capitalize first lettertsql capitalize first lettercapitalize first letter sql serversql upper first letter of each wordsql query to capitalize first letterhow to get capital leeters in sql serverfirst letter uppercase sqlsql select query for capital letterssql server first letter capitalhow to uppercase first letter in in sqlsql init capsql srv update colmn so that only first letter is upper casesql server capitalise first lettersql only first letter capitalcapitalize first letter sqlcapital letter sqlhow to set only first letter in uppercase sqlcovert first letter to uppercase in a table sqlt sql first letter of each word to uppercasesql only first character uperhow to capatelize first letter in sqlupper only first letter sqlcapitalize in sql servefunction in sql to return only first letter capitalsql check 1st letter is capitaluppercase first letter sqlcapitalize in sql sererhow to make first letter of each word capital in sql servercapitalize first letter of sql servesql check 1st letter is not capitalizedis it compulsory to use capital letter in sqlsql server string function for first letter in a wordhow can we make the first letter upper and remaining letter in lower case in sqlhow to have first letter upper case in sqlfirst letterupper in sqlcapitalize in sql serverupper case first letter sqlconvert first letter into capital block in sqlservercapital all letters sqlserverfirst letter uppercase in one collumn sqlhow to uppercase first letter in sql9 display the first letter of your name in uppercase using sql1st letter uppercase in sqlsql capitalize first letterfirst letter capital sql functionmssql first letter uppercasehow to convert first letter of string to uppercase in sqlcaps first leyter in sqlms sql first letter uppercase all wordhow to uppercase first latter in sqlhow to get capital letter first in sqlsqp capitalize first letterquery first letter of the last in uppercase 2bsql serverhow to get capital would sqlfirst letter capital in oracle sqlitesql select only capital letterssql find capital letters in a stringfirst letter capital in sql queryfirst char upper case sql serversql query for capital letterswhy write sql in letter capitalhow to get capital world sqlsql server month name with uppercase first lettercapitalize in roaclesql update statement with first letter in lowercasehow to make the first letter capital in sqlsql uppercase first lettersql string function for first letter in a wordcase when first letter is 0 then 27 27 mssqlsql first character upperhow to capitalise first letter in sqlfirst letter capital in sql in select querysql get value capital letter and lowercasesql make first letter uppercasehow to capitalize first letter in sql serversql capitalize first lettersdisplay first letter capital in sqlfinding capital a in sqlmake first letter capital sqlsql uppercase first letter of each wordconvert first letter of each word to uppercase in sqlsql server capitalize stringhow to change lower to upper case in sql of first letter in namesql like first char uppercase or lowercasesql server capitalize first letterfirstletter capitalize in sqlhow to uppercase the first letter of a string in sqlhow to get sql data as first latter capitalms sql first letter uppercasefirst letter uppercase in sqlfirst capital in sqlsql first letter uppercasecapitalize first letter when each word is capital in sql serverfisrt letter uppercase sqlhow to make first letter capital in sql nodesql to print in capital letterselect uppercase first letter ms sqlfirst letter capitalized sqlsql capitalize first letter of each wordsql command to set primary and start with capital letterfirstletter capital in sqlsql lowercase a wordfirst letter caps in sqlhow to check if first letter is capital in sqlhow to make first leeter to the capital for all records in sql plussql query for first letter capitalsql server capitalize first letter of each wordupper first letter sqlcase when first letter is t then 27 27 mssqlcapitalize first letter in a column sqlsql first letter upper casesql string functions upper case first latter casequery first letter of the last in uppercasesql upper case first lettersql lowercase except first lettert sql uppercase first letterhow to capitalize first letter in sql how to get capital letter first in sql