sql*plus INSERT problem

If I attempt to insert values into a VARCHAR2 field that contain the '&' character, sql*plus prompts me for the value of the argument specified by the string following the '&' character. Here is the scenario:

create table testtable (field1 varchar2(50)); insert into testtable values ('abcd&efg');

rather than inserting abcd&efg into field1, sql*plus gives me the prompt:

Enter value for efg:

How do I enter the & character in an insert statement????

Brad
bstinson_at_pinpoint.avl.com Received on Fri Nov 10 1995 - 00:00:00 CET