Using a "+" character in an SQL insert statement?

Posted in 2005

emailspaz@yahoo.com — 20 Sep 2005 04:16:49 -0700 — source: Usenet: comp.databases.informix

Part of a perl statement below - the "+" (AA+001) is messing things up. I've tried "\\+" (AA\\+001) but this no work. "DATABASE mydb;UPDATE mytable SET fielda='AA+001' WHERE fielda='ALL001'" Any help appreciated (Informix Dynamic Server Version 7.31.UC2)

↪ replying to emailspaz@yahoo.com

emailspaz@yahoo.com — 20 Sep 2005 04:34:36 -0700 — source: Usenet: comp.databases.informix

never mind.. there were some dos ^M characters confusing things in the SQL generation script from a DOS file. sorted...