MS Access Replace() Function

Posted by

MS Access

Replace()

Function

Example

Replace “i” with “a” in the string:

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


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