MS Access Split() 函数

示例

分割字符串：

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"}

定义和用法

Split() 函数将字符串拆分为字符串数组。

语法

Split( string, separator, limit, compare)

参数值

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

技术细节

工作于：	从 Access 2000

❮上一节 ❮ MS Access 功能下一节❯