Re: & symbol help!

Stephen,

If you are using SQLPlus, you can put a SET SCAN OFF and SET SCAN ON around your SELECT statement, and SQLPlus will ignore the & in your where clause (& is the default prompt/accept symbol). The other option is to SET DEFINE $character (or maybe "$character"), and SQLPlus will use another character as the symbol (I usually use ~). I'm not sure if the syntax is correct. Check your SQLPlus manual for more info.

-William Huang / <mailto:whuang_at_earthlink.net>

Stephen McClure <mailto:mcclure_at_primenet.com> wrote:
>
> I've got a value in a field with an & sybmol. Specifcally 8 L&D is the
> values. I'm trying to used the not in function. What syntax do I need
> to use to include this in my not in? Thanks in advance!
>
> --
> RESPECT - "Treat the earth well ... It was not given to us by our
> parents... It was lent to us by our children."
Received on Sat Mar 16 1996 - 00:00:00 CET