SQL Capitalize words in SQL (Display data first letter uppercase rest lowercase) - 08.06.18 | 22.11.19 - ErcanOPAK SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) - 1)) FROM tablename Related posts:Get a Tree view with SQL QueryUnique Constraints in MS SQL Server to prevent duplicationsGet the First and Last Word from a String or Sentence in SQLRename column SQL ServerHow to clean Query and Execution Plan Cache for Efficient Testing in MS SQL Post Views: 135