Re: inserting records (with & character)

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/02/13
Message-ID: <5dvgv9$dbt@shadow.CSUFresno.EDU>#1/1

In article <5dombj$54s_at_nuscc.nus.sg>,
Motley Crue, Vaxxer <chuacl_at_iscs.nus.sg> wrote:
>When I tried to insert a record contains a '&' character into a varchar2
>datatype column, it will prompt me for the value of string that appears after
>the & char, eg record is "t & t1"
>
>After I entered the insert sql statement, I'll get the following
>Enter value for t1:
>#after I pressed enter
>old : insert ....... values("t & t1")
>new : insert ....... values("t & ")

Try: insert ....... values('t '||chr(38)||' t1')  

The chr function can be used to insert any character.  

Steve Cosner

---

Try out my dynamic data utility form.
Quick display and update access to any table. http://members.aol.com/stevec5088 Received on Thu Feb 13 1997 - 00:00:00 CST