Split

Example

Divide strings into substrings based on specified delimiters.

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 divides a string into an array of substrings.

Syntax

Split(string, separator, limit, compare)

Parameter Values

Parameter	Description
string	Required. Specifies the string that will be divided into substrings.
separator	Optional. Specifies the separator used to divide the string into substrings. The default separator is a space character.
limit	Optional. Specifies the maximum number of substrings to return. The default value is -1, which returns all split substrings.
compare	Optional. Specifies the type of string comparison to use during the operation. Possible values: -1: Uses the setting of Option Compare 0: Performs a binary comparison 1: Performs a textual comparison

Technical Details

Works in:

From Access 2000