SQL Server query to print first letter of a Name in Upper Case and all other letter in Lower Case.

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 772
SQL Server query to print first letter of a Name in Upper Case and all other letter in Lower Case.

Select UPPER(SUBSTRING(Firstname, 1,1))+ 
LOWER(SUBSTRING(Firstname, 2, Len(FirstName)-1))As Firstname from tblDNFRec


Output:
Amatya
Anamika
Aditya
Amar
Bhushan
Bindu
Chahal
Diya
Girish
Hari
Irfan
Mayank
Ram
Rachna
Sachin
Shryansh
Swati
Talat
Urvi

Thanks
Amatya

Comments or Responses

Posted by: Gabriel on: 10/23/2017 Level:Starter | Status: [Member] | Points: 10
i do think this blog site is essential for approximately https://essay-reviewer.com/ legalized cannabis. many thanks for marijuana legalized write-up share with us.

Login to post response