How do Update fields with wildcard as a text

[Benjamins via AccessMonster.com]

Hi,

I have a update query "Update

Set [Field1] = 'O'Donnel' WHERE [Field2]
= 'Terry'"

It give me an error dur to the ' in O'Donnel. How do i Update/Insert
Wildcard.

 

[Tom van Stiphout]

On Mon, 18 May 2009 04:07:11 GMT, "Benjamins via AccessMonster.com"

Wildcard? Perhaps you meant "string terminator", because that's what a
single-quote is in some circumstances. Simply double-up on them:
Update

Set [Field1] = 'O''Donnel' WHERE [Field2] = 'Terry'

-Tom.
Microsoft Access MVP

 

[Marshall Barton]

I have a update query "Update

Set [Field1] = 'O'Donnel' WHERE [Field2]
= 'Terry'"

It give me an error dur to the ' in O'Donnel. How do i Update/Insert
Wildcard.

Or double up on the enclosing string delimiter:

"Update

Set [Field1] = ""O'Donnel"" WHERE [Field2] =
""Terry"""

 

[fredg]

Hi,

I have a update query "Update

Set [Field1] = 'O'Donnel' WHERE [Field2]
= 'Terry'"

It give me an error dur to the ' in O'Donnel. How do i Update/Insert
Wildcard.

I don't see any wildcards in your Update syntax.
I do see your problem however.
It has to do with the fact that your value O'Donnel has an apostrophe
within the surrounding apostrophes ('O'Donnel').
Use a double quote instead.

And why the quotes around the entire string?

Try:
Update

Set [Field1] = "O'Donnel" WHERE [Field2]
= "Terry"