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.