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.


Copyright © Thunderstone Software     Last updated: Jul 28 2017
Copyright © 2017 Thunderstone Software LLC. All rights reserved.