$PROPER
The $PROPER function shifts the first letter of each word in a string
to upper case and all other letters in the string to lower case. Words
are delimited by white space (tabs, newlines, blanks) or punctuation (:
; , . ! ?).
See also: LOWER, UPPER
Syntax
$PROPER(string)
string
Required. A string or scalar_expression that evaluates to a string.
Example
select $proper(company), upper(company), lower(company) from
customers where company='systems'
$PROPER: Dynamic Information Systems Corporation
UPPER: DYNAMIC INFORMATION SYSTEMS CORPORATION
LOWER: dynamic information systems corporation
Top
|