THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Trim() Function

❮ MS Access Functions

Example

Remove leading and trailing spaces from a string:

SELECT Trim("    SQL Tutorial    ") AS TrimmedString;
Try it Yourself »

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

❮ MS Access Functions