>I have a string variable I want to insert into a database. The variable contains both single and double quotes, and I'm having difficulty commenting out both sets of quotes. What is the proper syntax for doing so?
I am going to use the tilde [~] to represent the single quote and the asterisk to represent the double quote:
lcMyVar = chrtran(lcMyVar, "~", "")
lcMyVar = chrtran(lcMyVar, '*', '')
Mark McCasland
Midlothian, TX USA