PROPER

PROPER is a function that converts a string into its proper naming case. The first letter of each word is capitalized, and the other letters are in lowercase.

Syntax

string PROPER(string value)

Example

Can be used for various cases such as customer names, company names, product names and addresses:

PROPER("data synchronisation studio")

Will return "Data Synchronisation Studio".

You can pass column data into the function by entering the column name, such as:

PROPER(CompanyName)