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.