Re: How to deal with special character like & in ' '

choose use some other character for
define.
set define $ or so..
will let u insert string containing
&
 

Saurabh Sharma
 

saurabh00pc_at_yahoo.com<A
href="http://www.geocities.com/saurabh00pc/stride.html">http://www.geocities.com/saurabh00pc/stride.html <BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Kevin Lange To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Tuesday, July 24, 2001 3:03 AM Subject: RE: How to deal with special character like & in ' '

  Thanks Joe.   I did
  not know that command existed.    Makes life   easier.   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: JOE TESTA [<A     href="mailto:JTESTA_at_longaberger.com">mailto:JTESTA_at_longaberger.com]Sent:     Monday, July 23, 2001 1:49 PMTo: Multiple recipients of list     ORACLE-LSubject: Re: How to deal with special character like     & in ' '
    set scan off
     
    joe
    >>> lannyue_at_yahoo.com 07/23/01 01:51PM     >>>
    Hi,
    I want to insert a string like 'A&M University' but has problem with     '&'   I want the database exact A&M University. But it     always ask me new or old value because of symbol '&' how could I deal     with that. Thanks.
    HL          

    Do You Yahoo!?Make international calls for as low as $.04/minute     with Yahoo! Messenger<A
    href="http://phonecard.yahoo.com/?.refer=mailtagline">http://phonecard.yahoo.com/    Received on Tue Jul 24 2001 - 00:28:07 CDT