MS SQL server has built-in functions to convert a string to uppercase or lowercase. What about proper case / title case? Example: Convert DURBAN – SOUTH AFRICA to Durban – South Africa Below is a function that can do this. CREATE FUNCTION udf_ProperCase (@x varchar(7999)) RETURNS varchar(7999) AS BEGIN DECLARE @y int SET @y = […]
Nicholas