Re: sqlplus and the ampersand

Jenny,

The following is clunky, but it works:

select * from companys
where name = 'Baskin '||chr(38)||' Robbins';

Regards,

Ken

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.
>
Received on Fri Sep 19 1997 - 00:00:00 CDT