Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> simple SQL question I think
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 Mon Jul 06 1998 - 13:18:51 CDT