Re: Answer to "&" query

even easier...
sql> set scan off
sql> insert into junk values ('char_string_with_&_here');

BMI wrote:
>
> Actually that doesn't work. It states in the FAQ, change the set define
> value to something other than an &
>
> -Terry
>
> Mike Chan wrote in article <3422A808.1F9A_at_bigfoot.com>...
>
> >Below is the answer to those users which want "&" to be
> >interpreted as it is instead of asking for a value.
> >
> >in SQL*PLUS,
> > set escape /
> >
> >select ..... where .... = 'A/&tedB';
> >
> >Pls let me know if it works
 

-- 
------------------------------------------------------------
               DataWeb Consulting Services, Inc.
              "Web-enabling your databases today"
voice:(303)517-3863                       FAX:(303)422-5107
                       gkainz_at_rmi.net
------------------------------------------------------------