Reference Manual
   CHAPTER 9. SQL Statements     

READTEXT statement [T-SQL]

Function 

Reads text and image values, starting from a specified offset and reading a specified number of bytes.

Syntax 

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

Authorization 

Select permissions on the table.

Side effects 

None.

See also 

WRITETEXT statement

Description 

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

Standards and compatibility 

• SQL/92     Transact-SQL extension.

• Sybase     Supported by Adaptive Server Enterprise.

  Adaptive Server Enterprise supports the following clause, which is not supported by Adaptive Server Anywhere:

  USING { BYTES | CHARS | CHARACTERS }

  These options are identical for all single-byte character sets. Adaptive Server Anywhere uses bytes only, which is the Adaptive Server Enterprise default setting.

  Adaptive Server Enterprise also provides isolation level control in the READTEXT statement. This is not supported in Adaptive Server Anywhere.