Proper Case in Sql Server

DECLARE @Text As Varchar(200) = 'PROPERCASE Example in SQL Server by arKa guptA'

SELECT @Text = CONVERT(VARCHAR(500),UPPER(SUBSTRING(@Text,1,1)) + LOWER(SUBSTRING(@Text,2,499)))

SELECT @Text

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Propercase' AND xtype = 'FN')

BEGIN

      DROP FUNCTION Propercase

END

GO

CREATE FUNCTION Propercase

      (@STRING VARCHAR(8000)) RETURNS VARCHAR(8000)

AS

BEGIN

      SET @STRING = LOWER(@STRING)

      DECLARE @I INT

      SET @I = ASCII('a')

      WHILE @I <= ASCII('z')

      BEGIN

            SET @STRING = REPLACE( @STRING, ' ' + CHAR(@I), ' ' + CHAR(@I-32))

            SET @I = @I + 1

      END

      SET @STRING = CHAR(ASCII(LEFT(@STRING, 1))-32) + RIGHT(@STRING, LEN(@STRING)-1)

      RETURN @STRING

END

      GO

      GRANT EXECUTE ON Propercase TO PUBLIC

      GO

     

SELECT dbo.Propercase('PROPERCASE Example in SQL Server by arKa guptA')