Re: NVL in Informix?

>If a (char)column has null values and you concatenate(||) this column >with another non null(char), then you will get a null value(expression). >Oracle for example has NVL(column, "value") function >which allows you to "say" what value you want to be returned >if the value of the column is null. Is there any way to do this in Informix >without writing 4gl code(just SQL statements)? For ease of migration from Oracle to Informix this feature will be a part of the Informix Dynamic Server version 7.3. (Note that this is not an official announcement, but just my opinion from within the walls. Watch the web site and your sales team for the real scoop.) ___________________________________________________________ Clem Akins (aka clem@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: A Rebel Yank eating Aussie Cantonese with Kiwis