Capitalize First Letter

				
--**************************************
-- Name: Capitalize First Letter
-- Description:This is a User Defined Function (UDF) that will capitalize the first letter of a character after a space. It will also lowercase all capitalized words. This will only capitalize the first letter after the any space. Example: 'A CAT RAN DOWN' --> 'A Cat Ran Down' or 'a cat ran down' --> 'A Cat Ran Down'. Usage Select CapFirst('String')
-- By: Adonis Villanueva
--
-- Inputs:String input
--
-- Returns:Formatted String
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=663&lngWId=5--for details.--**************************************

CREATE function dbo.CapFirst (@String varchar(255))
returns varchar(255)
as
begin --begin function procedure
declare @StringCount int
set @string = lower(@string)
set @string = stuff(@string,1,1,left(upper(@string),1)) --Capitalize the first letter 
set @StringCount = 0
while @StringCount < len(@string)
begin --begin while
 if substring(@string,charindex(space(1),@string,@StringCount),1) = space(1)
 begin --begin if	
set @string = stuff(@string,charindex(space(1),@string,@StringCount)+1,1,substring(upper(@string),charindex(' ',@string,@StringCount)+1,1)) 
 end --end if
set @StringCount = @StringCount + 1
end --end while
return @string --return the formatted string
end --end function procedure