SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) - 1)) FROM tablename
Related posts:
Find numbers with more than two decimal places in SQL
Get the row number "x" from SQL
How to concatenate text from multiple rows into a single text string in SQL server?
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...
Convert a Comma-Delimited List to a Table in SQL