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/10/13 10:23:46