Neoview SQL Reference Manual (R2.4 SP2)

include a GROUP BY clause but you specify an aggregate function in the select list, all rows of
the SELECT result table form the one and only group.
See the individual entry for the function.
Character String Functions
These functions manipulate character strings and use a character value expression as an argument
or return a result of a character data type. Character string functions treat each single-byte or
multibyte character in an input string as one character, regardless of the byte length of the
character. For more information on using multibyte character sets, see the Neoview Character Sets
Administrator's Guide.
Returns the ASCII code value of the first character of a
character value expression.
“ASCII Function” (page 335)
Returns the specified code value in a character set.“CHAR Function” (page 348)
Returns the number of characters in a string. You can also
use CHARACTER_LENGTH.
“CHAR_LENGTH Function” (page 349)
Returns an unsigned integer that is the code point of the
first character in a character value expression that can be
associated with one of the supported character sets.
“CODE_VALUE Function” (page 351)
Returns the concatenation of two character value
expressions as a string value. You can also use the
concatenation operator (||).
“CONCAT Function” (page 352)
Returns a character string where a specified number of
characters within the character string have been deleted
and then a second character string has been inserted at a
specified start position.
“INSERT Function” (page 395)
Downshifts alphanumeric characters. You can also use
LOWER.
“LCASE Function” (page 399)
Returns the leftmost specified number of characters from
a character expression.
“LEFT Function” (page 400)
Returns the position of a specified substring within a
character string. You can also use POSITION.
“LOCATE Function” (page 401)
Downshifts alphanumeric characters. You can also use
LCASE.
“LOWER Function” (page 404)
Replaces the leftmost specified number of characters in a
character expression with a padding character.
“LPAD Function” (page 405)
Removes leading spaces from a character string.“LTRIM Function” (page 406)
Returns the length of a character string in bytes.“OCTET_LENGTH Function” (page 425)
Returns the position of a specified substring within a
character string. You can also use LOCATE.
“POSITION Function” (page 428)
Returns a character string composed of the evaluation of
a character expression repeated a specified number of
times.
“REPEAT Function” (page 435)
Returns a character string where all occurrences of a
specified character string in the original string are replaced
with another character string.
“REPLACE Function” (page 436)
Returns the rightmost specified number of characters from
a character expression.
“RIGHT Function” (page 437)
Replaces the rightmost specified number of characters in
a character expression with a padding character.
“RPAD Function” (page 442)
Removes trailing spaces from a character string.“RTRIM Function” (page 443)
Returns a character string consisting of a specified number
of spaces.
“SPACE Function” (page 455)
326 SQL Functions and Expressions