Inserting records into table with a string value containing an &
I have some records to insert into a table. Some of the string fields contain an ampersand "&" in their value. When I execute the SQL it (TOAD 8) takes it as a variable and ask me for a value to be assigned to the variable. How should I "escape" the ampersand??? Thanks in advance.