Removing NULL or Blank Not working.

[HelloCognos]

Hi, :) :) good morning!!

I have a listing of dates and they are all blank. In On-Demand, I'm trying to exclude these days or even in the Query using <> ' ' or NOT NULL. But
it is not taking these days off. I can't remember the command that I used to use "COLAPSE?? Something like that" that replaced 0 for blanks space.

Please help if you have a recommendation.

Thanks a lot

[Lynn]

Hi, :) :) good morning!!

I have a listing of dates and they are all blank. In On-Demand, I'm trying to exclude these days or even in the Query using <> ' ' or NOT NULL. But
it is not taking these days off. I can't remember the command that I used to use "COLAPSE?? Something like that" that replaced 0 for blanks space.

Please help if you have a recommendation.

Thanks a lot

Try using not equal to an empty string. Your example shows a blank space between two single quotes which is not the same thing as an empty string.

Code Select Expand


[your query item] <> ''


[HelloCognos]

Ah.. OK, I'll try that. No space. Thanks so much!