Selecting an emty date in Oracle Table

[#1]

Hi

I'm using QlikView against an Oracle database, and I'm trying to load data from a table.

I have this code so far:

LOAD *

where "ROLE" = 'Project Executive'

and "START_DATE_ACTIVE" < Today()

and "END_DATE_ACTIVE" >= Today();

SQL SELECT

"PROJECT_ID",

"ROLE",

"END_DATE_ACTIVE",

"START_DATE_ACTIVE",

"FULL_NAME"

as ProjExec

FROM APPS."PA_PROJECT_PLAYERS_V";

as part of the data load. The problem is that the "END_DATE_ACTIVE" is empty for the current Project Executives or it can be set to a future date.

How do I make an IF statement to handle this situation?

Thx

Hans Peter

[#2]

I have found the solution. I used the function

isnull("END_ACTIVE_DATE" and that worked....