Re: apostrophe in a string

Try

insert into dummy values ('jane''s cat', 'meow');

if you want to include an apostrophe then you must place two of them together. the first escapes the second.

Alan

Son To <son_at_blue.seas.upenn.edu> wrote in article <68b59v$37a$1_at_netnews.upenn.edu>...
> how can I insert an apostrophe?
> as in
> insert into dummy values('jane's cat','meow');
>
> i tried
> insert into dummy values('jane\'s cat','meow');
>
> but this did not work. any help is appreciated.
>
> thanks,
> son
>
> --
> "Challenge the known and embrace the unknown."
> -another fortune cookie
> Son To
> http://www.seas.upenn.edu/~son
>
Received on Tue Dec 30 1997 - 00:00:00 CST