Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » Text and Image FunctionRSS Feeds

TEXTPTR Function

Posted By: Sarita Patel     Category: SQL Server     Views: 4140

This article explains TEXTPTR function of sql server with examples.

TEXTPTR returns text-pointer value that corresponds to a text, ntext or image column in varbinary format. Text pointer value returned by TEXTPTR can be used in READTEXT, WRITETEXT and UPDATETEXT statements.


Syntax of TEXTPTR Function :

TEXTPTR (column)

column is the column of type text, ntext or image.

Return type of TEXTPTR function is varbinary.



Examples of TEXTPTR Function :

Example 1 : Use of TEXTPTR function in select clause

SELECT TEXTPTR()
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on TEXTPTR Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of TEXTPTR Function is from United States.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!