MS Access LTrim() Function

Remove leading spaces from a string:

SELECT LTrim(" SQL Tutorial") AS LeftTrimmedString;

Definition and Usage

The LTrim() function removes leading spaces from a string.

Note: See also the RTrim() function.

LTrim( string)

Parameter	Description
string	Required. The string to remove leading spaces from

Works in:	From Access 2000