textvalid

Returns 1 if the pointer to the specified text, unitext, in-row, and off-row LOB columns is valid; 0 if it is not.

Syntax

textvalid("table_name.column_name", textpointer)

Parameters

Examples

Usage

  • 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.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute textvalid.

Related concepts
text, image, and unitext Datatypes
Related reference
textptr