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

Posted by Amatya under Sql Server category on 9/26/2017 | Points: 40 | Views : 11655

Post Code |

Search Codes |

Code Home

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

Alert Moderator

Bookmark It

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.

Latest Code Snipptes

writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
More ...