Filtering out data in a WHERE clause based on CASE statement
Posted on 2007-12-03
In my SELECT statement I have several CASE statements. The 'ELSE' in one statement = NULL. I do not want to select the data where NULL is returned. For example, in the CASE statement, I am managing the company name from several different data sources with the ELSE = NULL. There are some instances in a specific data source where there is a data record and the 'cleansed' company name returned is NULL. I want to exclude that data from the SELECT. I'm assuming I should be able to do that in the WHERE clause but have been unsuccessful. Your assistance is greatly appreciated.