Cornillon, Matthieu wrote: > Hi. I know that the ampersand (&) character, when in an insert statement in > SQL*PLUS, causes a problem, because it's a special character. I am guessing > that there is a way to escape this out, but I can't figure it. Here is the > statement: > > INSERT INTO DEPARTMENTS > VALUES (1,2,3,'Mergers & Acquisitions'); > > Anyone know how to escape the &?
In many (most?) databases a backslash works as an escape character. Jochem ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
