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.


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