One thing I always seem to do now that I am getting older is forget things.  :)

In this case the "thing" I forgot was that when you use text based queries and must force a replace on apostrophes (') effectively doubling them so that your SQL will work correctly, you must remove all of those replace calls once you convert your text queries to stored procedures and begin to use parameters.  If you do not, you will end up doubling the number of apostrophes in your data each time it is saved.

Ah well, now I am starting to realize my parents and grandparents weren't crazy when they always blamed things on their failing memory.