Re: sql*plus INSERT problem

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_at_iterus.org
SAIC, ITER San Diego Joint Work Site
11025 North Torrey Pines Road, La Jolla, CA 92037