Use sp_drv_locator_to_unitext which accesses the Transact-SQL function return_lob.
sp_drv_locator_to_unitext locator
locator – unitext_locator to retrieve value of.
None.
A column containing the unitext value referenced by locator.
