Re: Where clause containing Ampersand

either set define off and verify off so it wont ask for it or use select 'Jay '||chr(38)||' Silent Bob' from dual;

James Alexander Starritt wrote:

> 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 Starritt