Use sp_drv_text_locator_charlength to find the character length of
a LOB column referenced by a text locator.
sp_drv_text_locator_charlength accesses the Transact-SQL function
char_length.
Syntax
sp_drv_text_locator_charlength locator, data_length
Input Parameters
locator – a text_locator that references the
text column to manipulate.
Output Parameters
data_length – an integer specifying the character
length of the text column referenced by
locator.