Book Contents

Book Index

Next Topic

Home

LTRIM

LTRIM returns a VARCHAR value representing a string with specific characters having been removed from the left side (beginning).

Syntax

LTRIM ( expression [ , characters ] )

Semantics

 

expression

(CHAR or VARCHAR) is the string to trim

characters

(CHAR or VARCHAR) specifies the characters to remove from the left side of expression. The default is the space character.

Examples

> SELECT LTRIM('zzzyyyyyyxxxxxxxxtrim', 'xyz');

ltrim

-------

trim

(1 row)