Capitalizes the first letter in each word of a string and converts all other letters to lowercase. Words are delimited by white space (a blank space, formfeed, newline, carriage return, tab, or vertical tab) and characters that are not alphanumeric. For example, if you pass the string ‘…THOMAS’, the function returns Thomas.
Syntax
INITCAP( string )
Argument
Required/
Optional
Description
string
Required
Any datatype except Binary. You can enter any valid expression.
Return Value
String. If the data contains multibyte characters, the return value depends on the code page of the Secure Agent that runs the task.
NULL if a value passed to the function is NULL.
Example
The following expression capitalizes all names in the FIRST_NAME column: