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: Apr 15 2024
Copyright © 2024 Thunderstone Software LLC. All rights reserved.