Re: How can I use '&' in VARCHAR2 fields ?

In article <8sn6k1$9do$1_at_nslave3.tin.it>,   "rdf" <deficis_at_show.it> wrote:
> Hi,
>
> I think the subject is all...!!!
> My example:
> INSERT INTO mytlb (myfield) VALUES ('/mypage.asp?par1=345&par2=234')
>
> I hope in your help.
> Thanks.
>

The easy solution is SET SCAN OFF

try following:

SET SCAN OFF;
INSERT INTO mytlb (myfield) VALUES ('/mypage.asp?par1=345&par2=234');

should work fine

hope this helps

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 19 2000 - 15:06:47 CDT