LOWER

All functions > STRING > LOWER

Converts all characters in a string to lowercase.

Syntax

LOWER(expr)
sql

Arguments

ParameterTypeRequiredDescription
stringVARCHARYesInput string to convert

Returns

String with all characters converted to lowercase

Notes

  • Affects only alphabetic characters
  • Non-alphabetic characters remain unchanged
  • Handles Unicode characters correctly

Examples

Last update at: 2025/11/06 07:00:15
Last updated: 2025-11-06 07:00:51