Tostringlen Function

Wed, 03/04/2009 - 20:02 |  hdanzl


Syntax

<tostringlen function> ::=

TOSTRINGLEN ( <value expression> , max-length )


Notes

♦ The TOSTRINGLEN function is equal to the TOSTRING function, except that the result is limited to the length specified by the max-length argument.
♦ The data type of the result is CHARACTER.
♦ If the value expression is null, then the result is null.


Examples

1) The following example shows a computed column with 100 characters extracted from a BLOB column:

       SELECT documentID, title, TOSTRINGLEN( content, 100 ) AS hex_content

       FROM documents

       ORDER BY documentID


Conformance

NexusDB extensions

-

TOSTRINGLEN function
‹ Tostring FunctionupDateTime Value Functions ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Functions | String Value Functions

Powered by Drupal and Drupal Theme created with Artisteer.