Re: simple SQL question I think

From: <rang_mk_at_my-dejanews.com>
Date: Tue, 07 Jul 1998 05:18:15 GMT
Message-ID: <6nsb2n$fqo$1@nnrp1.dejanews.com>

Hi there!

The work around to ur prob is

u can use in insert stament like this

insert into table (fld1)
values

('seeds '||'&'||' Oil Producing Seeds'); hope this helps.

bye
Rangan

In article <6nr4ea$drh$1_at_nnrp1.dejanews.com>, matsaki_at_statcan.ca wrote:
>
> Here's an easy one I hope:
>
> I'm trying to insert a string of text into a character field . The string
> includes an & symbol... eg: "Seeds & Oil Producing Seeds"
>
> I keep getting:
>
> old: "Seeds & Oil Producing Seeds"
> new: "Seeds Producting Seeds"
>
> Can someone help me out here? How do I force Oracle to take the & symbol?
> I've tried double single quotes around it, double quotes, but to no avail...
>
> Thanx in advance.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 07 1998 - 00:18:15 CDT