Re: select & in a literal

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: Sat, 30 Oct 1999 11:00:41 +0100
Message-ID: <7vefkg$ct1$1@news4.svr.pol.co.uk>

Naushi Hussain <Naushi.Hussain_at_Alliedsignal.com> wrote in message news:381A08E4.396F356E_at_Alliedsignal.com...
> How to use a select statement when one of the selected columns contains
> a '&' in its value
> when I issue a select statement it prompts me to enter a value instaed
> of printing the letter '&' .
>
> select col1 from table_a
>
> e.g. values of col1 is 'T&M'

In SQL*Plus:

SET SCAN OFF This will disable the prompting when an ampersand is encountered. Remember to turn it back on afterwards! Received on Sat Oct 30 1999 - 05:00:41 CDT