NexusDB Guide > SQL Reference > SQL Functions > String Value Functions

NexusDB V3 Manual

Tostringlen Function

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

nexus_logo