Returns the text expression with all letters in upper-case. The sytax is
upper(text[, mode])
For example:
SELECT NAME, upper(NAME)
FROM SYSTABLES
The results are:
NAME upper(NAME) SYSTABLES SYSTABLES SYSCOLUMNS SYSCOLUMNS SYSINDEX SYSINDEX SYSUSERS SYSUSERS SYSPERMS SYSPERMS SYSTRIG SYSTRIG SYSMETAINDEX SYSMETAINDEX |
Added in version 2.6.932060000.
The optional mode
argument is a string-folding mode in the
same format as <apicp stringcomparemode>; see the Vortex manual
for details on the syntax and default. If mode
is unspecified,
the current apicp stringcomparemode setting - with "+uppercase" added - is used. The mode
argument was added in
version 6.