Returns 1 if the pointer to the specified text or unitext column 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, 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”.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute textvalid.
Datatypes text, image, and unitext datatypes
Function textptr
Copyright © 2005. Sybase Inc. All rights reserved. |