Use sp_drv_locator_to_text, which accesses the Transact-SQL function return_lob
sp_drv_locator_to_text locator
locator – text_locator to retrieve value of.
None.
A column containing the text value referenced by locator.