TEXTVALID
A text, ntext, or image function that checks whether a given text pointer is valid.
Syntax
TEXTVALID ( 'table.column' , text_ ptr )
Arguments
table
Is the name of the table to be used.
column
Is the name of the column to be used.
text_ptr
Is the text pointer to be checked.
Return Types
int
Remarks
Returns 1 if the pointer is valid and 0 if the pointer is invalid. Note that the identifier for the text column must include the table name. You cannot use UPDATETEXT, WRITETEXT, or READTEXT without a valid text pointer.
These functions and statements are also useful with text, ntext, and image data.
| Function or statement | Description |
|---|---|
| PATINDEX('%pattern%', expression) | Returns the character position of a given character string in text and ntext columns. |
| DATALENGTH(expression) | Returns the length of data in text, ntext, and image columns. |
| SET TEXTSIZE | Returns the limit, in bytes, of the text, ntext, or image data to be returned with a SELECT statement. |
Examples
This example reports whether a valid text pointer exists for each value in the logo column of the pub_info table.
USE pubs
GO
SELECT pub_id, 'Valid (if 1) Text data'
= TEXTVALID ('pub_info.logo', TEXTPTR(logo))
FROM pub_info
ORDER BY pub_id
GO
Here is the result set:
pub_id Valid (if 1) Text data
------ ----------------------
0736 1
0877 1
1389 1
1622 1
1756 1
9901 1
9952 1
9999 1
(8 row(s) affected)