Use sp_drv_text_substring, which accesses the Transact-SQL
function substring.
Syntax
sp_drv_text_substring locator, start_position, length
Input Parameters
-
locator – a text_locator that
references the data to manipulate.
-
start_position – an integer
specifying the position of the first character to read and retrieve.
-
length – an integer specifying the
number of characters to read.
Result Set
A column of type text containing the substring retrieved.