textvalid

Description

Returns 1 if the pointer to the specified text or unitext column 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

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute textvalid.

See also

Datatypes text, image, and unitext datatypes

Function textptr