Wednesday, November 23, 2011

Having problems handling text that includes quotation marks ?

In this article, Doug Steele describes how you can handle quotations in SQL strings and queries that you may throw at either Access or SQL Server. At the end of the article you may still be confused but at least you will know where to come back to when you next tackle this thorny problem. I personally like the cQuote/Chr$(34) solution, its the easiest to read.

No comments: