Hi,

Not sure where this question fits, but it's fairly straightforward.

I have an ASP page with an SQL statement like so:

SELECT * FROM myTable WHERE status = 1 ORDER BY dateAdded

I have another field called expiryDate. I want to modify the SQL so that it does not return records which have passed their expiryDate.

However, most records will have a null value in their expiryDate field. If this is the case, I want them to be part of the recordset.

So I think I need something like this:

SELECT * FROM myTable WHERE status = 1 AND (expiryDate > GETDATE() OR expiryDate is null) ORDER BY dateAdded

Not sure what the syntax is.

thanks

s

Does you query not work, it looks fine to me. I would write it like:

SELECT * FROM myTable WHERE status = 1 AND ((expiryDate < GETDATE()) OR (expiryDate is NULL)) ORDER BY dateAdded;

FYI Its a good habit to include trailing semi colons at the end of all statements. Paste your queries into Query Analyser, change and run, change and run,.... to identify what works and what doesnt.

Wind is your friend
Matt

Thanks very much Matt. That's working now. I just had to change your code to

 ... ((expiryDate > GETDATE()) ...

That's expiryDate greater than ...

Cheers

s