Find and Replace Query with Wildcards in Access

[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)

 

[John Vinson]

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)

 

[Skip]

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)

 

[Guest]

John,

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

Thanks

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)

 

[John Vinson]

John,

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

Sorry! Left off a closing parenthesis:

UPDATE

SET (e-mail address removed)

 

[Guest]

Thanks John, that worked great!

John,

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

Sorry! Left off a closing parenthesis:

UPDATE

SET (e-mail address removed)