Re: Type casting qustion

Posted in 1998

J.Miguel Signes — Thu, 18 Jun 1998 08:33:16 +0200 — source: Informix-list mailing list archive (1991-1998)

Damir Kropf wrote: ... > 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 ? ... I'd rather try to replace all occurrences of the string "<> ''" with "is not null". Un saludo. -- ----------------------------------------------------------------------- J.Miguel Signes (msignes@san.gva.es). Tel: 96.386.86.30 Servei d'Inform'tica. Conselleria de Sanitat. Generalitat Valenciana. -----------------------------------------------------------------------