SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) – 1)) FROM tablename
Tag: upper
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (848)
- Get the First and Last Word from a String or Sentence in SQL (756)
- How to select distinct rows in a datatable in C# (704)
- How to add default value for Entity Framework migrations for DateTime and Bool (584)
- Add Constraint to SQL Table to ensure email contains @ (521)