Removing apostrophes

G

Guest

Is there an easy way to remove an apostrophe from a text field or do you have
to loop finding instrings several times and removing it before using in an
insert statement?
[email protected]
 
D

Duane Hookom

Consider the Replace() function. This might depend on your version of Acces.
 
M

Marshall Barton

Spammastergrand said:
Is there an easy way to remove an apostrophe from a text field or do you have
to loop finding instrings several times and removing it before using in an
insert statement?
Click to expand...


A2K introduced the Replace function. You can use it in an
Update query to do what you want:

Replace(thefield, "'", "")
 
Top