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