Re: Syntax Help

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Thu, 9 Jun 2005 22:41:04 +0000 (UTC)
Message-ID: <d8agi0$re0$1@klatschtante.init7.net>

On 2005-06-09, WebTracer <randy_at_webtracersolutions.com> wrote:
> I am trying to insert a record into a table. The text that was given
> to me includes the following piece:
>
> 'IRIS,IP&OP SLOT,'
>
> Oracle (TOAD specifically) errors on this ... how do I insert the &
> into a text field? I know there are ways in VB, VBA and C++ to force
> this to go in ... but I can't remember how to do it in SQL.

'IRIS,IP' || chr(38) || 'OP SLOT,'

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Thu Jun 09 2005 - 17:41:04 CDT