SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) – 1)) FROM tablename
Tag: lower
Recent Posts
Most Viewed Posts
- Get the First and Last Word from a String or Sentence in SQL (243)
- How to use Map Mode for Vertical Scroll Mode in Visual Studio (194)
- How to make some specific word(s) Bold or Underline in ReportViewer (187)
- How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (182)
- Confirm before process with ASPxButton in Devexpress (170)