Camel Case Function

gistfile1.txt

CREATE FUNCTION [dbo].[CamelCase]
    (
     @Str     VARCHAR(8000)
    )
RETURNS VARCHAR(8000)
AS
     BEGIN
          DECLARE @Result     VARCHAR(2000)
          SET @Str = LOWER(@Str) + ' '
          SET @Result = ''
          WHILE 1 = 1
          BEGIN
               IF PATINDEX('% %' ,@Str) = 0
               BEGIN
                    BREAK
               END
               SET @Result = @Result + UPPER(LEFT(@Str ,1)) + SUBSTRING(@Str ,2 ,CHARINDEX(' ' ,@Str) - 1)
               SET @Str = SUBSTRING(@Str ,CHARINDEX(' ' ,@Str) + 1 ,LEN(@Str))
          END
          SET @Result = LEFT(@Result ,LEN(@Result))
          RETURN @Result
     END