First Create a Function as below and use the same.
It takes the input value in a string and it finds the white space and make the next text to white space as Upper 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
SELECT DBO.FN_TITLECASE('I GOT YOUR REQUIREMENT KINDLY MAKE A NOTE')