MS Access Trim() Function

Posted by

MS Access

Trim()

Function

Example

Remove leading and trailing spaces from a string:

SELECT Trim(”    SQL Tutorial    “) AS TrimmedString;


Definition and Usage

The Trim() function removes both leading and trailing spaces from a string.

Syntax

Trim(

string

)

Parameter Values

Parameter Description

string
Required. The string to strip both leading and trailing spaces from

Technical Details

Works in: From Access 2000