Re: inserting the value "&"

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Mon, 30 Dec 2002 13:07:20 +0100
Message-ID: <aupctp$l4f$1@bambi.zdv.Uni-Mainz.DE>

Rauf Sarwar wrote:

> Try this,
>
> INSERT INTO dirs
> (dirName,
> ip)
> VALUES
> ('/BALD RUNTER/Simon '|| CHR(38) ||' Garfunkel - The Definitive
> (1994)/', '134.93.40.167');
>
> CHR(38) is the ASCII value of &.

Thanks for your answer, but I managed to solve the problem by myself. Only thing I had to do was to:
set escape '\';
INSERT INTO dirs

     (dirName,
      ip)
    VALUES
     ('/BALD RUNTER/Simon \& Garfunkel - The Definitive
     (1994)/', '134.93.40.167');

Regards Moritz Received on Mon Dec 30 2002 - 06:07:20 CST