Informix equalent of Oracle's GREATEST() function?

[Siva Prasad Reddy Katamreddy]

Hi,

I have a table with 3 date columns and i want to find the maximum of 3 columns.

For Ex:
Table : EMPLOYEE(ID, Date1, Date2, Date3)

Now i want to execute the query:
SELECT ID, GREATEST(DATE1,, Date2, Date3) MAX_DATE FROM EMPLOYEE;

But Informix doesn't have support for GREATEST() function.

How can i do it in Informix?

Thanks,
Siva