Oracle SQL*Plus and the '&' character ...... help needed .....

Hi,

        Currently I have a table ( Oracle V7.2.3 ) that has data in a field that contains the '&' character. The field name is component_number and the data is 'F&GS '. I want to change this data to something else but each time I run the script is comes back and says 'Enter value for GS :' . It thinks that it is a variable. How do I get the script to run straight through and get SQL*Plus to recognise this '&' as data.?? Do I use some other character that oracle recognises as the & character ?. I am getting frustrated and would apreciate any help someone can give.

        Please reply here in this newsgroup or e-mail me directly at langi_at_netspace.net.au

                        Thanks, Ian Lang Received on Sun May 19 1996 - 00:00:00 CEST