SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) - 1)) FROM tablename
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) - 1)) FROM tablename