目录

MS Access Replace() 函数

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

示例

将字符串中的 "i" 替换为 "a"：

SELECT Replace("My name is Willy Wonka", "i", "a") AS ReplaceString;

定义和用法

Replace() 函数将字符串中的一个子字符串替换为另一个子字符串，指定的次数。

语法

Replace( string1, find, replacement, start, count, compare)

参数值

Parameter	Description
string1	Required. The original string
find	Required. The substring to search for in string1
replacement	Required. The substring to replace find in string1
start	Optional. The start position in string1 to begin the search. If omitted, start is 1
count	Optional. The number of replaces to perform. If omitted, it will replace all occurrences of find with replacement
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 功能下一节❯