Having a ' symbol in Names

[bloody_football]

I have thousands of cards in my database. If the name of the card has the ' symbol in it (e.g Aladdin's Ring) then the database returns an error because it beleives the ' in the name is an instruction.

Any way around this?

James

 

[Kodo]

you must replace the single apostrophe with two. For instance: if I had a variable (LastName) that held the value "O'Reily" and I used this variable in an insert statement, then it would throw an error. What you need to do is this:

LastName=replace(LastName,"'","''")

 

[bloody_football]

Thank you