how do i remove quotes and double quotes

[wheels27]

i need to run a query to remove qoutes " and also double quote "" how do i do this
they appear on the end of some text "like this" and also "like,"this" so how iwll go about removing them i know it will probobaly be an update or delete query


thanks
nick

 

[m6]

Dear wheels27,

Yes, an update query and there is a 2 fold problem to the find and replace depending on what version of Access your on. 97 doesn't have and one of cohorts here has a great one as a function in a module. 2000 has a replace function.

Tx,

m6

 

[cmmrfrds]

Try the replace function. The following replaces a single quote with 2 single quotes.

Dim var as string
var = Replace(var, "'", "''&quot