Use this statement to read text and image values from the database, starting from a specified offset and reading a specified number of bytes.

Syntax

READTEXT table-name.column-name
text-pointer-offset-size  
[ HOLDLOCK ]

Remarks

READTEXT is used to read image and text values from the database. You cannot perform READTEXT operations on views.

Permissions

SELECT permissions on the table.

Side effects

None.

See also

• WRITETEXT statement [T-SQL]
• GET DATA statement [ESQL]
• TEXTPTR function [Text and image]

Standards and compatibility