SQL•SQL References

MS Access LTrim() Function

Example

SELECT LTrim("    SQL Tutorial") AS
LeftTrimmedString;

Definition and Usage

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

Note

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

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT LTrim("    SQL Tutorial") AS
LeftTrimmedString;

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

Note

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

Works in:	From Access 2000