Re: hide & character

From: n <n_at_m.com>
Date: 2000/07/16
Message-ID: <#fXEXP67$GA.287@cpmsnbbsa09>#1/1

Or escape it using the set escape command. Drey.

Paul Druker <pdruker_at_metaway.com> wrote in message news:2uuc5.2619$MS4.176523_at_typhoon.southeast.rr.com...
> I'm not sure I really understand your question. I guess you may get
problems
> in SQL*Plus while executing this statement because of the ampersand. In
this
> case you may use "set define" command to redefine it.
>
> HTH,
> Paul
>
>
>
> "James Young" <hpya78_at_postoffice.pacbell.net> wrote in message
> news:39724E3E.A2DC2720_at_postoffice.pacbell.net...
> > Hello
> > I have a command like
> >
> > insert into customers
> > (cust_num, company, cust_rep, credit_limit)
> > values (2113, 'Ian & Schmidt', 104, 20000.00);
> >
> > Can anyone tell me how to hide &
> > Thank
> >
>
>
Received on Sun Jul 16 2000 - 00:00:00 CDT