Skip to main content

Description

Removes leading spaces from a string field. Trailing spaces are kept. Only the space character is removed. Leading tabs and line breaks are kept. To remove all leading and trailing whitespace, use TRIM. To remove only trailing spaces, use RTRIM.

Syntax

LTRIM(string_expression)

Examples

LTRIM(' John Smith ') returns ‘John Smith ’ UPPER(LTRIM(RTRIM(' ab '))) returns ‘AB’

Return value datatype

String

Impact of null value

If input is null, returns null.
Last modified on November 17, 2026