I need to create a cursor which has the max date from four date fields in the table, but the following code won't work.

Any idears?

Thanks

John

SELECT Field1, Field2, MAX(Date1,Date2,Date3,Date4) AS Date;
FROM Table ;
INTO CURSOR TempTable
<\PRE>