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