Inserting text including &

Hello there,
I need some help inserting a text field that includes an &.

example:

insert into table_name values ('word1 & word2');

This would cause sqlplus to prompt me for the value of word2.

anyway to solve that problem.
Thanks a million in advance.

Khal Received on Sat Jul 03 1999 - 16:45:20 CDT