>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


Hi ,

SELECT CHARINDEX('TEST', Column_table) from ...

this command return the initial position of the 'TEST' in column_table