Re: sqlplus and the ampersand

Jenny Farnham wrote:
>
> How do you keep the ampersand "&"
> from literally being interpreted
> in an IN statement. When the sqlplus
> code is run... it is prompting the
> user for a value. For example:
>
> select count(*)
> from companys
> where name in ('Baskin & Robbins');
>
> This will generate a prompt. We tried
> double quotes too (ex. ")
>
> Thanks in advance.
>

Hi,

ever tried chr(integer)-function?

select count(*)
from companys
where name in ('Baskin ' || chr(xx) || ' Robbins');  

-- 
Regards

M.Gresz    :-)