LTRIM

Use LTRIM to trim, or eliminate, the leading spaces of a character string or to trim specific characters from a string.

The first parameter is the string property or value to trim. A second optional parameter, the trim string, is the character or characters to trim from the left of the string. If the second parameter is omitted, leading spaces are trimmed from the left side of the string.

The trim string characters do not have to be in pattern order; each character is trimmed individually. Supported trim string characters are 0-9, a-z, A-Z, spaces, and select special characters. Not all special characters are supported.

Syntax

LTRIM(stringproperty)
LTRIM(stringproperty, trim_string)

Example

SELECT LTRIM('  1234Baseball'), LTRIM('  1234Baseball','21 ')

Result: 1234Baseball, 34Baseball