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

NexusDB V3 Manual

Char Function

Syntax

<char function> ::=

Notes

§	The CHR function returns a character corresponding to the value of the argument.

§	The argument shall be within the range 1..255.

§	If the argument is null, then the result is null.

Examples

1)	The following example selects all customer rows with a CR/LF pair in the Memo column:

SELECT *

FROM customers

WHERE memo LIKE '%' || CHR( 13 ) || CHR( 10 ) || '%'

Conformance

NexusDB extensions

CHR function

nexus_logo