Neoview SQL Reference Manual (R2.2)

CODE_VALUE Function

The CODE_VALUE function returns an unsigned integer (INTEGER UNSIGNED) that is the

code point of the first character in a character value expression that can be associated with any

character sets allowed.

CODE_VALUE is a Neoview SQL extension.

CODE_VALUE(character-value-expression)

character-value-expression

is a character string.

Example of CODE_VALUE Function

This function returns 97 as the result:

>>select code_value('abc') from (values(1))x;

(EXPR)

----------

304 SQL Functions and Expressions