CREATE function fn_TitleCase
(
	@my_str as varchar(8000)
)
Returns varchar (8000)
AS
Begin

	Declare @this_str as varchar(8000)
	Declare @word_str as varchar(5000)
	Declare @spc int

	If NULLIF(@my_str, NULL) is Null 
	Begin
		Return Null
	End
	Select @this_str = ''
	
	Select
		@my_str = LTrim(RTrim(@my_str))
	
	While Len(@my_str) > 0
		Begin
		
			if (CharIndex(' ', @my_str) = 0)
				Begin
					Select
						@spc = Len(@my_str)
				End
			Else
				Begin
					Select
						@spc = CharIndex(' ', @my_str)
				End
	
				Select
					@word_str = LTrim(RTrim(Left(@my_str, @spc))),
					@my_str = LTrim(RTrim(Right(@my_str, (Len(@my_str)-@spc))))
			
			

				Select
					@this_str = RTrim(LTrim(@this_str + ' ' + (Upper(Left(@word_str,1)) + Lower(Right(@word_str,(Len(@word_str)-1))))))
		End

	Return (@this_str)
End