Finding Position of Byte Sequence Referenced by an Image Locator within the Image Column Referenced by Another Locator

Use sp_drv_image_locator_charindex, which accesses the Transact-SQL function charindex.

Syntax

sp_drv_image_locator_charindex sequence_locator, locator, start, start_position

Input Parameters

  • sequence_locator – an image_locator that points to the byte sequence to search for.

  • locator – an image_locator that references the image column to search from.

  • start – an integer specifying the position from which to begin searching. The first position is 1.

Output Parameters

start_position – an integer specifying the starting position of the byte sequence in the LOB column referenced by locator.

Result Set

None.

Parent topic: Adaptive Server Enterprise ODBC Driver Support