Rob,

> The SQL standard specifies that single quotes are to be used around string
> literals (<fieldname>='<value>') in SQL statements. Some implementations
> of SQL allow double-quotes, but many require single-quotes.
>
> Does anyone know of a way to handle saving (with SQL UPDATE or INSERT) of
> strings that contain internal apostrophes (single quotes), preserving the
> single quotes within the string?

it depends on how the particular tool you're using handles them.
I believe that in the vast majority of cases you just double each quote.
Eg. insert into mytable values ('isn''t it?', ...);
HTH
--
____
_/\/ando