This is an old revision of the document!


DRAFT

Omnidex SQL Function: CASE

Description

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( <column_spec } 'string' > )
<column_spec } 'string' >

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

Example

Example 1

select $proper(company), upper(company), lower(company) from customers where company='systems'

$PROPER: Dynamic Information Systems Corporation

 
Back to top
dev/sql/functions/proper.1260196423.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)