Use sp_drv_image_substring, which accesses the Transact-SQL
function substring.
Syntax
sp_drv_image_substring locator, start_position, length
Input Parameters
-
locator – an image_locator that
references the data to manipulate.
-
start_position – an integer
specifying the position of the first byte to read and retrieve.
-
length – an integer specifying the
number of bytes to read.
Result Set
A column of type image containing the substring retrieved.