Returns 1 if the pointer to the specified text, unitext, in-row, and off-row LOB columns is valid; 0 if it is not.
textvalid("table_name.column_name", textpointer)
is the name of a table and its text column.
is a text pointer value.
Reports whether a valid text pointer exists for each value in the blurb column of the texttest table:
select textvalid ("texttest.blurb", textptr(blurb)) from texttest
textvalid checks that a given text pointer is valid. Returns 1 if the pointer is valid, or 0 if it is not.
The identifier for the column must include the table name.
For general information about text and image functions, see Transact-SQL Users Guide.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute textvalid.
Datatypes text, image, and unitext datatypes
Documentation Transact-SQL Users Guide
Function textptr
