Re: single quotes within insert/update stmts

Amit,

Use two single quotes to denote a literal quote inside a string, thus:

insert into user_profile values
  ('username','select a,b,c,''my string'',d,e,f from ....');

Robert Proffitt

In article <38B54C64.A2352374_at_cs.man.ac.uk>,   Amit Patel <patela6_at_cs.man.ac.uk> wrote:
> I have an insert stmt as follows:
>
> insert into user_profile values ('username', 'select.....');
>
> within the 2nd argument ('select.....') there exists several single
> quotes (')
> How can I modify the stmt so that the insert doesnt get confused
between
> single qutes within the argument to be inserted and the final single
> quote to delimit the argument.
>
> Any possible Suggestions would be helpful
>
> Thanks
>
> Anit
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 24 2000 - 10:15:13 CST