Finding position of a string referenced by a unitext locator within the unitext column referenced by another locator

Use sp_drv_unitext_locator_charindex which accesses the Transact-SQL function charindex.

Syntax

sp_drv_charindex_unitextloc_in_locator search_locator, locator, start,
position

Input Parameters

Output Parameters

position – an integer specifying the starting position of the literal in the LOB column referenced by locator.

Result Set

None.