Database insertion problems

Problem: Insert into Test Values ('Bugs & Daffy'); this statement translates as substitution variable Daffy.
Solution: Insert into Test Values ('Bugs''&''Daffy'); this statement gets the job done. Field String_Field contains: 'Bugs&Daffy'


Problem in Inserting quotes:
Solution:To insert quote, in the place of quote, use 2 quotesthat use '' instead of '