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

table_name.column_name – is the name of a table and its text column.
textpointer – is a text pointer value.

Examples

Example 1 – 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 
```

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.

Parent topic: Transact-SQL Functions

Related concepts

text, image, and unitext Datatypes

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com