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 leading and trailing spaces from a string.

Syntax

Trim(string)

Parameter Values

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

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

❮ MS Access Functions