THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Split() Function

❮ MS Access Functions

Example

Split strings:

SELECT RTrim("SQL Tutorial is fun!") AS SplitString;
Result: {"SQL", "Tutorial", "is", "fun!"}

SELECT Split ("one:two:three", ":") AS SplitString;
Result: {"one", "two", "three"}

Definition and Usage

The Split() function splits a string into substrings (based on a delimiter), and returns the result as an array of substrings.

Syntax

Split(string, delimiter, limit, compare)

Parameter Values

Parameter Description
string Required. The string to split
delimiter Optional. The delimiter used to split the string into substrings. The default is a space character
limit Optional. The maximum number of substrings splits from string. The default is -1, which will split all substrings
compare Optional. The type of comparison to perform.

Possible values:
0: Binary comparison
1: Textual comparison

Technical Details

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

❮ MS Access Functions