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:Convert a Comma-Delimited List to a Table in SQLUnique Constraints in MS SQL Server to prevent duplicationsHow to find records based on CAPITAL and small letters in SQL Query?How to use Replicate function for masking in SQL?How to Alter a Computed Column in SQL? Post Views: 135