Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Where clause containing Ampersand
I have a where clause that contains an & as part of it. Oracle prompts for
a value, assuming that this is a variable. How do I put a literal ampersand
in my where clause.
update table
set field = 'New Text'
where field = 'Jay & Silent Bob';
Any ideas. Should be easy as pie but I can't figure it out
-- James StarrittReceived on Tue Dec 18 2001 - 08:52:10 CST