Share this article:

What it does: The LOWER() Function converts text to lowercase.

Plain English: Simple. This function converts text to be all lowercase.

  • So “AppLe” would become “apple”.
  • “EMPloyee” would become “employee”

This is a great little tool to make text strings equal while you compare them. There could be mistakes in capitalization that crept in or simply different naming conventions that would otherwise make two text strings unable to compare equally.

Arguments: LOWER(text)

  • Text – The text you want to convert to lowercase