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.
sp_drv_text_locator_charlength locator, data_length
locator – a text_locator that references the text column to manipulate.
data_length – an integer specifying the character length of the text column referenced by locator.
None.