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