Write down a SQL Query to convert first letter in Upper case and Rest

1.	Write down a SQL Query to convert first letter in Upper case and Rest in lower case in Name?
Answer» Write down a SQL QUERY to CONVERT FIRST LETTER in UPPER case and Rest in lower case in Name? To write down this query i have created a #temptable and then write query to convert firstname in proper case

Discussion