MS Access LTrim() Function

Posted by

MS Access

LTrim()

Function

Example

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.

Syntax

LTrim(

string

)

Parameter Values

Parameter Description

string
Required. The string to remove leading spaces from

Technical Details

Works in: From Access 2000