Replacing quotation marks

[J. Muenchbourg]

The following removes any unwanted apostrophes before being inserted
into an sql database:

Articletext = replace(articleText,"'","''")

..but if I need to remove all quotation marks, this doesnt work:

Articletext = replace(articleText,""","''")
????
Muench

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Beschler]

"" = empty string
""" = empty string + extra "

To place a " into a string use "".

Your code would then be:
Articletext = replace(articleText,"""","''")
or alternately:
Articletext = replace(articleText,CHR(34),"''")

HTH,
John

-----Original Message-----
The following removes any unwanted apostrophes before being insertedinto an sql database:

Articletext = replace(articleText,"'","''")

..but if I need to remove all quotation marks, this doesnt work:
Articletext = replace(articleText,""","''")
????
Muench

*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
.

[Alan]

You need to double-up apostrophes to stop them interfering with the
delimiters needed around textual column contents - why do you need to
double-up quotes?

Alan

"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:#w**************@TK2MSFTNGP09.phx.gbl...

The following removes any unwanted apostrophes before being inserted
into an sql database:

Articletext = replace(articleText,"'","''")

.but if I need to remove all quotation marks, this doesnt work:

Articletext = replace(articleText,""","''")
????
Muench

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!