THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Replace() Function

❮ MS Access Functions

Example

Replace "i" with "a" in the string:

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

Definition and Usage

The Replace() function replaces a substring within a string, with another substring, a specified number of times.

Syntax

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

Parameter Values

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

Technical Details

Works in: From Access 2000

❮ MS Access Functions