UCASE or UPPER function
Derby Reference Manual
144
VALUES TRIM('by' FROM ' derby')
UCASE or UPPER function
UCASE or UPPER takes a character expression as a parameter and returns a string in
which all alpha characters have been converted to uppercase.
Syntax
UCASE or UPPER ( CharacterExpression )
If the parameter type is CHAR , the return type is CHAR. Otherwise, the return type is
VARCHAR.
Note: UPPER and LOWER follow the database locale. See
for
more information about specifying locale.
The length and maximum length of the returned value are the same as the length and
maximum length of the parameter.
Example
To return the string
aSD1#w
in uppercase, use the following clause:
VALUES UPPER('aSD1#w')
The value returned is
ASD1#W
.
USER function
When used outside stored routines, USER,
, and
return the authorization identifier of the user that created the SQL session.
SESSION_USER also always returns this value when used within stored routines.
If used within a stored routine created with EXTERNAL SECURITY DEFINER, however,
USER and CURRENT_USER return the authorization identifier of the user that owns the
schema of the routine. This is usually the creating user, although the database owner
could be the creator as well.
For information about definer's and invoker's rights, see
.
Syntax
USER
Example
VALUES USER
VARCHAR function
The VARCHAR function returns a varying-length character string representation of a
character string.
Character to varchar syntax
VARCHAR (CharacterStringExpression )
CharacterStringExpression
An expression whose value must be of a character-string data type with a maximum
length of 32,672 bytes.
Datetime to varchar syntax
