You shouldn't need it for this application, but to answer you question: At least in Oracle, two single quotes together is an escape sequence to convert to one single quote; 'I''m comin'' ova' converts to the data "I'm comin' ova". As Raymond said though, when you're doing a substitution inside a CFQuery, the single quotes in the data are automatically escaped. Can you post some code? Brian -----Original Message----- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 8:53 PM To: CF-Talk Subject: Re: SQL syntax problem ok, i am confused. what do i type to get this character ' and why is it different from this character ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
