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

On Wed, 17 Sep 1997 18:24:55 -0400, David Kramer <Dskramer_at_concentric.net> wrote:

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

Use the ASCII equivalent CHR(<....>)

Maybe you can define another character as macro character.

• Martin Jesterhoudt
• martinj(replace this by @)worldonline.nl

  ---