Loading
Salesforce Enforces New Security Requirements in Summer 2026Read More
Extend Salesforce with Clicks, Not Code
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          LOWER

          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