Use sp_drv_varchar_charindex, which accesses the Transact-SQL function charindex.
search_string – the literal, of type varchar, to search for.
locator – a text_locator that references the text column to search from.
start – an integer specifying the position from which to begin searching. The first position is 1.