Informix SQL "is null" syntax

Posted on 2010-08-24
Medium Priority
Last Modified: 2013-12-24
I have a table column that contains blank values and null values I want it to only display blank values

I am used to SQL syntax not informix I believe the below would work in SQL how can it work in informix?

select column1, column2, IS NULL(column3, "") as 'column3 no nulls'
from table1
Question by:JCTDD
  • 2
LVL 58

Accepted Solution

cyberkiwi earned 2000 total points
ID: 33517884
select column1, column2, NVL(column3, "") as 'column3 no nulls'
from table1
LVL 58

Expert Comment

ID: 33517885
The Ansi SQL92 standard is to use COALESCE, but not sure which version of Informix you are using or whether that version supports COALESCE.

Expert Comment

ID: 33517888
select column1, column2, NVL(column3, "") as 'column3 no nulls'
from table1

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question