use test1 SELECT CASE WHEN (dbo.Table_2.dtReception >=dbo.Table_2.dtManipulation AND dbo.Table_2.dtReception >= dbo.Table_2.dtDelivrance) THEN dbo.Table_2.dtReception WHEN (dbo.Table_2.dtManipulation >=dbo.Table_2.dtReception AND dbo.Table_2.dtManipulation >= dbo.Table_2.dtDelivrance) THEN dbo.Table_2.dtManipulation ELSE dbo.Table_2.dtDelivrance END