Re: how do I put a & in a varchar2?

David Kramer wrote:
>
> This sounds stupid, but I can't find this in three different Oracle books.
>
> If I use a & in my insert, it thinks I'm defining a variable. In fact,
> I'm inserting a URL into a field in my database. How do I escape it?
>
> TIA.
>
> -------------------------------------------------------------------
> DDDD David Kramer dskramer_at_concentric.net
> DK KD http://www.concentric.net/~dskramer
> DKK D
> DK KD "Time's fun when you're having flies." -- Kermit the Frog
> DDDD
Hi,

ever tried chr(integer)-function?

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

-- 
Regards

M.Gresz    :-)