>>Use the built-in quote() function. -- Just what I'm after (huge sigh of relief) Is it sqlite3_quote?
I had a search through the documentation and didn't come up with anything. Obviously I didn't look hard enough. I'll go back and look again. Thanks very much for the quick response and apologies if this is a common question. R.