How do I get rid of strange special characters?

[forever_newbie]

I had a word article that I was going to insert into sql server in a text
field. So I replaced every occurrence of apostrophe by two apostrophes (sql
server doesn't like seeing single apostrophes in the middle of a text field).
What I didn't notice was that this replace doesn't work the way you would
expect (in Word). When you try and replace one apostrophe by two, you get a
reverse slanted character followed by an apostrophe. Since I didn't notice
this, I went ahead and inserted the word as text into a sql field, and now
my sql database is full of these characters. I have to get rid of them, so
the question is - what are they?
Thanks,

 

[Suzanne S. Barnhill]

Possibly a grave accent? Usually on the top left key on a U.S. keyboard.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[FOREVER_NEWBIE]

No, its not a grave accent. Try it yourself - create a word such as
Mary's and then do a search/replace of the apostrophe by 2
apostrophes. At least in Word 2000, it creates 2 characters, and
neither of them are a grave character.
-- Thanks

 

[Suzanne S. Barnhill]

I would expect an opening single quote in this context.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

No, its not a grave accent. Try it yourself - create a word such as
Mary's and then do a search/replace of the apostrophe by 2
apostrophes. At least in Word 2000, it creates 2 characters, and
neither of them are a grave character.
-- Thanks