Getting the Last Word from a Sentence in a given String using Sql Server.

DECLARE @Sentence VARCHAR(100) = 'Dot Net funda is a good site';
SELECT REVERSE(LEFT(REVERSE(@Sentence),
CHARINDEX(' ',REVERSE(@Sentence))- 1)) AS [Last_Word]