Null date

[pushaskhelp]

I have one table with id,name,submission date and followup date.
followup date may be null.
i have to select id from this table where followupdate is less than given date.
and if followup date is null then I have to select id from this table where submission date is less than given date.

[code green]

A comparison to a NULL is meaningless.
You could use COALESCE

WHERE given date >= COALESCE(followupdate,submission)

[debasisdas]

then select it, what is the problem ?

[Jerry Winston]

Can you share your query?

[viktorka]

@b0010100
You can try to play around something like:

SELECT * FROM table1 where followup < @date and followup is not null
Union
SELECT * FROM table1 where is not null and submissionDate < @date

[Jerry Winston]

Code Green said it best: "A comparison to a null is meaningless"

Try using isNULL(field,'ValueIfNull'):

SELECT * FROM table1 where NOT isNull(followup,'NULL') = 'NULL' 
AND
followup < @date
Union
SELECT * FROM table1 where NOT isNull(submissionDate,'ThisDateISNULL') = 'ThisDateISNULL'
AND 
submissionDate < @date