ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

TEXTPTR function [Text and image]

Function 

Returns the 16-byte binary pointer to the first page of the specified text column.

Syntax 

TEXTPTR (  column-name  )

Parameters 

column-name    The name of a text column.

Usage 

This function is included for Transact-SQL compatibility.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

Use TEXTPTR to locate the text column, copy, associated with au_id 486-29-1786 in the author's blurbs table.

The text pointer is put into a local variable @val and supplied as a parameter to the readtext command, which returns 5 bytes, starting at the second byte (offset of 1).

DECLARE @val VARBINARY(16)
SELECT @val = TEXTPTR(copy)
FROM blurbs
WHERE au_id = "486-29-1786"
READTEXT blurbs.copy @val 1 5