SQL Sweeper Tweak for Apostrophes

One of the pitfalls of using SQL databases is that you have to be extra cautious handling apostrophes. Apostrophes (or single quote marks) are used by SQL to delimit field values so when a field value has an apostrophe as part of the value (e.g., O'Hara) it can cause problems. A customer found the latest example in the SQL Sweeper tool. He was unable to make changes to a field value that contained an apostrophe. I have fixed that issue and you can download the update but there may be other apostrophe issues still lurking in parts of the system that we haven't found yet. Always report any error messages to us so we can keep improving.