Insert syntax

Hi,

I'm trying to insert a text string into a table but am having problems with the syntax when using the '&' operator. I want to use the '&' in a text string on an insert

e.g.

insert into table products values
('123', '1', 'FISH & CHIPS'); Only when I try using the '&' sign I get an error?

Cheers Received on Mon Mar 01 2004 - 14:41:12 CST