How is everybody dealing with SQL Passthrough when passing large areas of text
(memos) typically back to the server? In particular, I see problems with
embedded string delimiters (') and potentially CHR(0)'s and other control
characters when sending back binary data.

If I were to send a string like this: "It's a nice day"

and then use: "INSERT SomeTable(SomeMemo) VALUES('"+lcText+"')"

where lcText contains the string above it'll blow up on account of the
embedded quote.

What am I missing?

+++ Rick ---