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/11/06 07:00:15
Last updated: 2025-11-06 07:00:51