|
Capitalizes text. The syntax is
initcap(text)
Returns the text expression with the first letter of each word in
title case (ie. 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.
Copyright © Thunderstone Software Last updated: Wed Aug 6 10:57:07 EDT 2008
|