SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) – 1)) FROM tablename
Tag: lower
Recent Posts
- How to create the ShowBlanksValue and ShowNonBlanksValue items in Devex Grid
- How to get ‘n’th row in Sql Query with OFFSET FETCH NEXT and ROW_NUMBER()
- How to change the style of scrollbar with CSS
- How to add scroll bar to div in Asp.Net
- How to solve “Fatal: Not possible to fast-forward, aborting” problem
Most Viewed Posts
- Get the First and Last Word from a String or Sentence in SQL (362)
- How to use Map Mode for Vertical Scroll Mode in Visual Studio (234)
- Find numbers with more than two decimal places in SQL (205)
- Add Constraint to SQL Table to ensure email contains @ (201)
- Confirm before process with ASPxButton in Devexpress (200)