Returns a zero-based, one-dimensional array (array: A variable that contains a finite number of elements that have a common name and data type. Each element of an array is identified by a unique index number. Changes made to one element of an array don't affect the other elements.) containing a specified number of substrings.
Split(expression [, delimiter ] [, limit ] [, compare ] )
The Split function syntax has these arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
The compare argument can have the following values:
||Performs a comparison using the setting of the Option Compare statement.
||Performs a binary comparison.
||Performs a textual comparison.
||Microsoft Office Access 2007 only. Performs a comparison based on information in your database.