lower

Returns the text expression with all letters in lower-case. The syntax is

  lower(text[, mode])

For example:

     SELECT  NAME, lower(NAME)
     FROM    SYSTABLES

The results are:

NAME lower(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 "+lowercase" aded - is used. The mode argument was added in version 6.