MS Access Split() Function

Posted by

MS Access

Split()

Function

Example

Split strings:

SELECT Split(“SQL TutorialĀ is fun!”) AS SplitString;
Result: {“SQL”,
“Tutorial”, “is”, “fun!”}
SELECT Split (“red:green:yellow:blue”, “:”, 2) AS SplitString;
Result: {“red”, “green”}


Definition and Usage

The Split() function splits a string into an array of strings.

Syntax

Split(

string

,

separator

,

limit

,

compare

)

Parameter Values

Parameter Description

string
Required. The string to split

separator
Optional. The separator used to split the string. The
default is a space character

limit
Optional. The number of strings to be returned. The
default is -1, which returns all strings (splitted)

compare
Optional. The type of string comparison.
Possible values:
-1: Use the setting of Option Compare
0: Binary comparison
1: Textual comparison
2: Comparison based on info in your database

Technical Details

Works in: From Access 2000