Just this script is based on your information..CREATE TABLE Test1 (InspectionDate date, [Type] char(1), DueDate AS case when InspectionDate = '1/1/2012' and [type] = 'A' THEN dateadd(DD, 1, InspectionDate) when InspectionDate = '1/1/2012' and [type] = 'B' THEN dateadd(DD, 20, InspectionDate) ELSE InspectionDate end )--I need to update DueDate field(automatically??)with different date values depending on the values in InspectDate & Type fields.INSERT INTO Test1(InspectionDate, Type) VALUES ('1/1/2012', 'A'), ('1/1/2012', 'B')GOSELECT * FROM Test1GODROP TABLE Test1
--Chandu