SQL Functions

$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)

$PROPER()

Required.

string

Required. A string or scalar_expression that evaluates to a string.

top

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