SQL Server how to change 1 letter from lower case into upper case

stellusm...

SOLVED CLOSED ACTIVE ANSWERED
User: stellusmca
Posted: on May 06, 2016 02:27 AM
Forum: SQL Server
Answer: 1
Views: 2516

Hi All, i want to convert my table value from upper case to lowercase in sql server. i have tried my code below but am not get any output, i want to convert first letter of the word into lowercase eg: Test=test select CONVERT(VARCHAR,YEAR(GETDATE()))+'_'+DATENAME(MM,GETDATE()) OUTPUT: 2016_May EXPECTED OUTPUT: 2016_may thanks in advance.

Download FREE API for Word, Excel and PDF in ASP.Net

Shashika...

0 1

Reply
ANSWER
User: Shashikant
Replied: on May 06, 2016 02:28 AM
Report

Hi,

Please refer below code

SQL

SELECT CONVERT(VARCHAR,YEAR(GETDATE()))+'_'+ LOWER(DATENAME(MM,GETDATE()))

Output

2016_may

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

SQL Server how to change 1 letter from lower case into upper case

Company

Explore

Follow us

Contact Us