initcap

Capitalizes text. The syntax is

initcap(text[, mode])

Returns the text expression with the first letter of each word in title case (i.e. upper case), and all other letters in lower-case. For example:

SELECT  NAME, initcap(NAME)
     FROM    SYSTABLES

The results are:

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


Copyright © Thunderstone Software     Last updated: Oct 5 2023
Copyright © 2024 Thunderstone Software LLC. All rights reserved.