How to read data with single quote embedded in the data
I need to read data from another table. It contains text that has embedded single quotes - i.e. O'Rouke. I think I need to use the Replace function to replace the single quote with 3 single quotes. Is this right?