Re: Converting apostrophes for insertion into Oracle

John: When you say that your SQL statement has apostrophes, you mean single quotes enclosing a string value ?, if this is the case, why not try changing the single quotes in your SQL for double quotes. Saludos, Pablo _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Monday, February 05, 2001, 3:03:21 PM, John wrote: AJ> I've got a web form that might have someone entering apostrophes. AJ> Unfortunately, my SQL statement has apostrophes in it and it seems to be AJ> messing it up... AJ> Any suggestions other than a regex (which I could do myself)? AJ> John AJ> --------------------- AJ> John Asendorf - jasendorf@lcounty.com AJ> Web Applications Developer AJ> http://www.lcounty.com - NEW FEATURES ADDED DAILY! AJ> Licking County, Ohio, USA AJ> 740-349-3631 AJ> The benefit to the government of replacing all $1 Federal Reserve notes with AJ> $1 coins would be $522.2 million per year, according to estimates of the AJ> General Accouting Office released on April 7, 2000.