LTRIM( ) function

Returns a string with leading spaces removed from the input value.

Syntax

LTRIM(string)

Parameters

string

Character. The value to remove leading spaces from.

Output

Character.

Remarks

This function removes leading spaces only. Spaces inside the string, and trailing spaces, are not removed.

The LTRIM( ) function is related to the TRIM( ) function, which removes any trailing spaces from a string, and to the ALLTRIM( ) function, which removes both leading and trailing spaces.

Examples

Example Return value

LTRIM("   Vancouver   ")

“Vancouver   “

LTRIM("   New York   ")

“New York   “

Note that in both examples the trailing spaces are not removed by the LTRIM( ) function.

Related reference
ALLTRIM( ) function
TRIM( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback