Re: single quotes within insert/update stmts

From: Hakan Eren <heren_at_home.com>
Date: Thu, 24 Feb 2000 15:42:03 GMT
Message-ID: <38B5518D.96214606@home.com>

Hi

You need to use two quotes.

Ex:

SQLWKS> insert into temp_progress values('test''another''')

     2> /
1 row processed.
SQLWKS> select * from temp_progress

     2> /
TEMP                                                                            
--------------------------------------------------------------------------------
test'another'                                                                   

1 row selected.

Hakan

Amit Patel 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
Received on Thu Feb 24 2000 - 09:42:03 CST