Returns 1 if the pointer to the specified text column is valid; 0 if it is not.
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, a text and image function, checks that a given text pointer is valid. Returns 1 if the pointer is valid or 0 if it is not.
The identifier for a text or an image column must include the table name.
For general information about text and image functions, see “Text and image functions”.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute textvalid.
Datatypes text and image datatypes