upper

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.