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.