See CHARINDEX function in BOL.
SELECT CHARINDEX('TEST', 'This is a test.')
>Hi,
>
>I would like to find the word
>TEST
>within a string that may or may not contain this word.
>What is the best method to accomplish this.
>
>I actually want to return the position in the string the word starts.
>
>Any ideas?
>
>Thanks
--sb--