Type casting qustion

Posted in 1998

Damir Kropf — Wed, 17 Jun 1998 13:20:07 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, Suppose you created table 't1' with only one column - 'c1' of type smallint. Insert some data into table (e.g. 1,2,3,4 ...). Following SQL statement returnted all values from the table in Informix version 5, while Informix 7.x returns no rows: sql select * from t1 where c1 <> '' As we have a number of similar SQL statements in a number of applications is there a way to revert SQL cast behaviour in Informix 7 to that of Informix 5 ? All the best, Damir Kropf -- 4-MATE Information Engineering http://www.4mate.hr http://www.4bank.com