LTRIM

Removes spaces from the left hand side of a string.

Syntax

string LTRIM(string value)

Example

To remove the spaces from the string " Four spaces are at the beginning of this string." you can use the following:

LTRIM("    Four spaces are at the beginning of this string.")

This will remove the leading spaces and return "Four spaces are at the beginning of this string."

You can apply this to a column from your data source by entering the column name into the brackets.

LTRIM(MyColumn)