Text and image functions

Text and image functions operate on text, image, and unitext data. The text and image functions are:

Text and image built-in function names are not keywords. Use the set textsize option to limit the amount of text, image, and unitext data that is retrieved by a select statement.

You can use the patindex text function on text, image, and unitext columns and can consider it on a text and image function.

You can use the datalength function to display the length of data in text, image, and unitext columns.