Re: simple SQL question I think

From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: Thu, 09 Jul 1998 23:56:24 GMT
Message-ID: <01bdab95$2f1dc980$049a0580@mcb>

Split your value apart and concatenate:

select 'Seeds '||'&'||' Oil Producing Seeds' from dual;

'SEEDS'||'&'||'OILPRODUCING

---

Seeds & Oil Producing Seeds

That's a select, but I would imagine an insert would work the same way...? --
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

matsaki_at_statcan.ca wrote in article <6nr4ea$drh$1_at_nnrp1.dejanews.com>...
> 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
Received on Thu Jul 09 1998 - 18:56:24 CDT