Char Function

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


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
‹ Trim FunctionupTostring Function ›
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.