How can I extract most recent dates (three fields)?

[irinnew]

Hi everybody
Could you please give me a hand?

I have the following columns in the table :
Date1, Date2, Date 3 (Date2 or 3 can be empty)

In case all three dates or at least 2 of them are populated I need just records with the most recent Date.

How can I do it?

Thank you in advance!

Irin

 

[JarlH]

Do you mean you want the most recent date from each *row* in the table?

If thats the case, try something like

SELECT CASE WHEN c3 > c1 AND (c3 > c2 OR c2 IS NULL) THEN c3
WHEN c2 > c1 THEN c2
ELSE c1 END AS most_recent
FROM datestable