ASCII ProperCase Function

,

Another Proper case function that utilises the ASCII function to convert to Proper case

Useage

SELECT [dbo].[fnProperCase](' CONVERT tHis toPROpper cASE')

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

Rate

2.5 (4)

Share

Share

Rate

2.5 (4)