MS Access Split() Function
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 |
|---|
