Another Proper case function that utilises the ASCII function to convert to Proper case
Useage
SELECT [dbo].[fnProperCase](' CONVERT tHis toPROpper cASE')
ASCII ProperCase Function
ALTER FUNCTION [dbo].[fnProperCase]
(
@InputString VARCHAR(2000)
)
RETURNS VARCHAR(2000)
AS
BEGIN
SET @InputString = LTRIM(RTRIM(LOWER(@InputString)))
DECLARE @Returnvalue VARCHAR(2000)=''
DECLARE @i INT =1
DECLARE @Space INT
WHILE @i <= LEN(@InputString)
BEGIN
SELECT @Returnvalue +=CASE WHEN (@i =1 OR @i = @Space)
THEN CHAR(ASCII(SUBSTRING(@InputString,@i,1))-32)
ELSE SUBSTRING(@InputString,@i,1)
END
SET @Space = CHARINDEX(' ',@InputString,@i)+1
SET @i +=1
END
RETURN @Returnvalue
END