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