Returns the 16-byte binary pointer to the first page of the specified text column.
TEXTPTR( column-name )
column-name The name of a text column.
BINARY
This function is included for Transact-SQL compatibility.
SQL/2003 Vendor extension.
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; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |