See Re: Show maximum of 3 columns Thread #557471 Message #557488

>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
>