using & in a string.

Hi,

I have a string that says : 'Front & back' I want to insert that string into a table :

Insert Into Table1 (Description) values ('Front & back') ;

resulting in :

old 1: Insert into table1 (Description) values ('Front & back') ; new 1: Insert into table1 (Description) values ('Front ') ;

1 row created.

My questions are :
1- Why this is happening?
2- How can I avoid that?

(I found something for question number 2, but let see if you can come with something better.)

thanks

Patrick

--


"She just love my big 10 inch
 record of her favorite blues"  - S.T.