How to check string contains specific word in sql

CHARINDEX ( StringToFind ,OverAllStringToSearch [ , start_location ] )

DECLARE @str VARCHAR(100)
SET @str='How are you'
SELECT CHARINDEX('are',@str)

Output = 5