Find and Replace Query with Wildcards in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a Find and Replace query with wildcards. For example,
I have e-mail addresses that have country codes in them such as
"(e-mail address removed)". I wish to get rid of the country codes in all of the
e-mail address so that they read simply "(e-mail address removed)". There are
different country codes in each e-mail address, so I need to use wildcards.
I have tried to use the Replace function with something like this:
UPDATE

SET
.email = Replace (e-mail address removed)
 
I am trying to create a Find and Replace query with wildcards. For example,
I have e-mail addresses that have country codes in them such as
"(e-mail address removed)". I wish to get rid of the country codes in all of the
e-mail address so that they read simply "(e-mail address removed)". There are
different country codes in each e-mail address, so I need to use wildcards.
I have tried to use the Replace function with something like this:
UPDATE

SET
.email = Replace (e-mail address removed)
Click to expand...
 
GoFlyersCS said:
I am trying to create a Find and Replace query with wildcards. For example,
I have e-mail addresses that have country codes in them such as
"(e-mail address removed)". I wish to get rid of the country codes in all of the
e-mail address so that they read simply "(e-mail address removed)". There are
different country codes in each e-mail address, so I need to use wildcards.
I have tried to use the Replace function with something like this:
UPDATE

SET
.email = Replace (e-mail address removed)
Click to expand...
 
John,

I get a "Syntax Error (missing operator)" when I try to save that query.
Any thoughts?

Thanks

John Vinson said:
I am trying to create a Find and Replace query with wildcards. For example,
I have e-mail addresses that have country codes in them such as
"(e-mail address removed)". I wish to get rid of the country codes in all of the
e-mail address so that they read simply "(e-mail address removed)". There are
different country codes in each e-mail address, so I need to use wildcards.
I have tried to use the Replace function with something like this:
UPDATE

SET
.email = Replace (e-mail address removed)
Click to expand...
Click to expand...
 
John,

I get a "Syntax Error (missing operator)" when I try to save that query.
Any thoughts?
Click to expand...

Sorry! Left off a closing parenthesis:

UPDATE

SET (e-mail address removed)
 
Back
Top