Can't Update or Delete Row

[witchblade]

I did something stupid, but what else is knew...
I cannot update or delete a certain row in a table in my Oracle database.
I entered data in a field as 'Tasha & Ed'.
:-s

I know that in PL/SQL, when it sees me typing in Delete or Update 'Tasha & Ed', it thinks I'm asking the user to enter a value for a prompt because of the ampersand.

Any way I try it, I always get the following prompt-
Enter value for ed:

I am using this table in a Java program with XML and I can't solve the XML error with this row still in the database.

Please Help, help, help, help, help.

 

[carp]

Try 'Tasha \& Ed'

 

[witchblade]

Thanks CARP. |-0
I did it using LIKE 'Tasha%';