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: 2026/01/19 16:14:19
Last updated: 2026-01-19 16:14:54