LTRIM

All functions > STRING > LTRIM

Removes whitespace from the left (beginning) of a string.

Syntax

LTRIM(expr)
sql

Arguments

ParameterTypeRequiredDescription
stringVARCHARYesString to trim

Returns

String with leading whitespace removed

Notes

  • Removes spaces, tabs, newlines from the beginning only
  • Trailing whitespace is preserved
  • Middle whitespace is preserved

Examples

Last update at: 2025/10/13 10:23:46