| Below is the syntax to find a word in any of string or use of indexof keyword in sql. We use CHARINDEX keyword to get the string
declare @findtext as varchar(50)
declare @FreeText as varchar(4000)
set @findtext='crack'
set @FreeText='here in this website you will get help to crack your interview'
select charindex (@findtext,@FreeText)
And the anser you get from above syntax
43 as crack starts from 43 character
| | |