Previous Topic

Next Topic

Proper - SQL Function

Proper(String: String): String

Returns String in proper case, that is, capitalises the first letter in a text string and other letters in text that follow a character other than a letter. Converts all other letters to lower case letters.

Proper function syntax has these named arguments:

Parameter

Description

String

Required. String to return in proper case.

For example:

  Proper("emily jones")

Returns: Emily Jones

See Also

SQL String Functions

Book Contents

Book Index