Loading
Prepare for Email to Become the Default Login ExperienceRead More
Ongoing maintenance for Salesforce HelpRead More
Extend Salesforce with Clicks, Not Code
LOWER

You are here:

  1. Salesforce Help
  2. Docs
  3. Extend Salesforce with Clicks, Not Code

LOWER

Converts all letters in the specified text string to lowercase. Any characters that are not letters are unaffected by this function. Locale rules are applied if a locale is provided.

Use

LOWER(text, [locale]) and replace text with the field or text you wish to convert to lowercase, and locale with the optional two-character ISO language code or five-character locale code, if available.

MYCOMPANY.COM Example
MYCOMPANY.COM Example

LOWER("MYCOMPANY.COM") returns “mycompany.com.”

Ticker Symbol Example
Ticker Symbol Example

LOWER(TickerSymbol) returns the text in Ticker Symbol in lower case characters.

Turkish Language Locale Rules Example
Turkish Language Locale Rules Example

The Turkish language has two versions of the letter “i”: one dotted and one dotless. The locale rules for Turkish require the ability to capitalize the dotted i, and allow the dotless I to be lowercase. To correctly use the LOWER() function with the Turkish language locale, use the Turkish locale code tr in the LOWER() function as follows:

LOWER(text, "tr")

Using this locale code ensures that Salesforce doesn’t transform any dotted i in the text to a dotless I.

 
Loading
Salesforce Help | Article