From: Michele Garb Subject: Re: sql*plus INSERT problem Date: 1995/11/11 Message-ID: <48139a$qve@rs3.rz.uni-hohenheim.de>#1/1 references: to: Brad,Stinson, content-type: text/plain; charset=us-ascii organization: S.A.I.C x-url: news:NEWTNews.816043152.13898.bstinson@bns.avl.com mime-version: 1.0 newsgroups: comp.databases.oracle x-mailer: Mozilla 1.12 (X11; I; AIX 2) As you've already been told & is a reserved character and in sqlplus it will alway think that you are using the & to represent a variable. I do however know of one way to get around this. Put the & character between single quotes and then concatinate it to the rest of your string. So for instanse if you are trying to set ENAME in the EMP table to "Jan & Tom" the syntax would be: insert into EMP (ENAME) values ('Jan '||'&'||' Tom'); -- Michele Garb garbm@iterus.org SAIC, ITER San Diego Joint Work Site 11025 North Torrey Pines Road, La Jolla, CA 92037