Re: apostrophe in a string

Try the following:-
insert into dummy values('jane''s cat','meow');

Hope this helps,

Manoj Jain
Oracle DBA

Son To wrote:

> 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 Mon Jan 05 1998 - 00:00:00 CST