SQL SERVER||How to make city names in Proper-case in SQL?

How to make city names in Proper way in SQL? SELECT city_name ,UPPER(LEFT(city_name,1))+LOWER(SUBSTRING(city_name,2,LEN(city_name))) AS Proper_CityName FROM [dbo].[Address_tbl] SELECT city_name ,CONCAT(UPPER(LEFT(city_name,1)),LOWER(SUBSTRING(city_name,2,LEN(city_name)))) AS Proper_CityName FROM [dbo].[Address_tbl]