Escaping/protecting special string characters
Posted on 2003-03-24
One of the fields in my database contains data with many special characters like single and double quotes and number(#) signs. Right now, those characters appear as a square on the screen. I know I need to replace them with a " for example, so I thought I could use something like the Replace or ReplaceList functions but I'm not sure how to tell the machine what it's looking for. Short of doing the physical replace in the actual database, what can I do?