help me with &&

[wwalice]

Hi,
Now i have a table emp (name varchar2(200)).
I inserted data as below:

insert into emp values ( 'tony & stone');

i was prompted:
enter value for stone:

I know that because the "&" in the statement. I really want it in the table. So how could i disable the meaning of "&"?
I used \& to try. It failed.

Any ideas?

[mber]

Do this;

insert into emp
values('tom'||'&'||'bob');

Take Care

[wwalice]

Hi, Mber:

I got it!
Thanks very much!