LeftTrim

Description

Removes spaces from the beginning of a string.

Syntax

LeftTrim ( string )

Argument

Description

string

The string you want returned with leading spaces deleted

Returns

String. Returns a copy of string with leading spaces deleted if it succeeds and the empty string (“”) if an error occurs.

Examples

Example 1

This expression returns RUTH:

LeftTrim(" RUTH")

Example 2

This expression for a computed field deletes any leading blanks from the value in the column lname and returns the value preceded by the salutation specified in salut_emp:

salut_emp + " " +  LeftTrim(lname)

See also