LTRIM Function

Description

The LTRIM function removes all specified characters from the left-hand side of a string.

Syntax

LTRIM( string [, trim_string])

 

string :

character string

string valued column

NULL

 

trim_string :

character string

NULL

Example

--trimming spaces on the left

SELECT LTRIM ('     Olympic     ');

  ltrim('     Olympic     ')

======================

  'Olympic     '

 

--If NULL is specified, it returns NULL

SELECT LTRIM ('iiiiiOlympiciiiii', NULL);

  ltrim('iiiiiOlympiciiiii', null)

======================

  NULL

 

-- trimming specific strings on the left

SELECT LTRIM ('iiiiiOlympiciiiii', 'i');

  ltrim('iiiiiOlympiciiiii', 'i')

======================

  'Olympiciiiii'