SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) – 1)) FROM tablename
Tag: lower
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (704)
- Get the First and Last Word from a String or Sentence in SQL (697)
- How to select distinct rows in a datatable in C# (559)
- Add Constraint to SQL Table to ensure email contains @ (455)
- Average of all values in a column that are not zero in SQL (372)