Title case (Proper case) Function in Sql Server 2005

The following function in Sql server 2005 changes the string to its equivalent Title Case.

CREATE FUNCTION fn_TitleCase (@InputStr VARCHAR(250))    
RETURNS Varchar(250)    
AS BEGIN    
DECLARE @TempStr VARCHAR(250)    
DECLARE @i INT    
SET @TempStr = LOWER(@InputStr)    
SET @TempStr = UPPER(LEFT(@TempStr,1)) + SUBSTRING(@TempStr,2,LEN(@TempStr))    
    
WHILE CHARINDEX(' ',@TempStr,1) > 0    
 BEGIN    
  SET @i = CHARINDEX(' ',@TempStr,1)    
  SET @TempStr = LEFT(@TempStr,@i-1) + '~*' + 
UPPER(SUBSTRING(@TempStr,@i + 1,1)) +SUBSTRING(@TempStr,@i+2,LEN(@TempStr))    
 END    
     
    
 SET @TempStr = REPLACE(@TempStr,'~*',' ')    
 SET @InputStr = @TempStr    
 RETURN @InputStr    
END    

Create this Above Function and can be used as

	Select dbo.fn_TitleCase('i am the best')

Result: I Am The Best