readtext

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

Syntax

readtext [[database.]owner.]table_name.column_name
	text_pointer offset size 
	[holdlock | noholdlock] [readpast]
	[using {bytes | chars | characters}]
	[at isolation {
		[read uncommitted | 0] | 
		[read committed | 1] |
		[repeatable read | 2]| 
		[serializable | 3]}]

Parameters

Examples

Usage

See also text, image, and unitext Datatypes in Reference Manual: Building Blocks.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

readtext requires select permission on the table.

Related reference
set
writetext