Re: Answer to "&" query

In article <3422A808.1F9A_at_bigfoot.com>,   mike.chan_at_bigfoot.com wrote:
>
> 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/&B';
>
> Pls let me know if it works

An alternative would be:

  in SQL*PLUS
    set scan off

  select ..... where .... = 'A&B';

Bob England
rengland_at_apci.net
rengland_at_fvh.gtegsc.com
GTE Government Systems

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet