Unable to concatenate a string to a column

Posted in 1994

Keith Davies — Tue, 23 Aug 1994 20:18:55 GMT — source: Informix-list mailing list archive (1991-1998)

I'm using Informix-OnLine 4.10, and if I try to concatenate a character column with a string, eg SELECT column1 || "a text string" FROM table1; the statement is rejected with: 202: An illegal character has been found in the statement. Is concatenation only supported in later versions of Informix? -- Keith Davies Internet: keith@keithd.demon.co.uk Tel.: +44 582 833651