Cacher is the code snippet organizer for pro developers

CREATE   function ProperCase(@Text   AS   varchar(8000))  
 returns varchar(8000)  
 AS  
 BEGIN  
      DECLARE   @Reset   BIT   ;  
      DECLARE   @Ret varchar(8000);  
      DECLARE   @i   INT   ;  
      DECLARE   @c   CHAR   (1);  

      SELECT   @Reset   =   1, @i   =   1, @Ret   =    ''   ;  
     
   WHILE (@i   <=   len(@Text))  
       SELECT   @c   =    SUBSTRING   (@Text,@i,1),  
               @Ret   =   @Ret   +    CASE    WHEN   @Reset   =   1   THEN    UPPER   (@c)   ELSE    LOWER   (@c) end,  
               @Reset   =    CASE    WHEN   @c   LIKE    '[a-zA-Z]'    THEN   0   ELSE   1 end,  
               @i   =   @i   +   1  
   return @Ret  
 end  




 SELECT   dbo.ProperCase(   'this,my friends, is a test.wHat DO you think?i like shaquile o''neal'   )