Use sp_drv_create_text_locator to create a text_locator and optionally initialize it with value. sp_drv_create_text_locator accesses the Transact-SQL function create_locator.
sp_drv_create_text_locator [init_value]
init_value – a varchar or text value used to initialize the new locator.
None.
A column of type text_locator. The LOB that the locator references has init_value when supplied.