From ssharma1@fcsltd.com Mon, 23 Jul 2001 22:28:07 -0700
From: "Saurabh Sharma" <ssharma1@fcsltd.com>
Date: Mon, 23 Jul 2001 22:28:07 -0700
Subject: Re: How to deal with special character like & in ' '
Message-ID: <F001.00352C35.20010723222521@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



choose use some other character for 
define. 
set define $ or so..
will let u insert string containing 
&
 
Saurabh Sharma
 
saurabh00pc@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@fatcity.com" 
  title=ORACLE-L@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@longaberger.com">mailto:JTESTA@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@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/