I have a field value which will have the following

2 days

1 week

1 month

1 month 2 days

I want to create a trigger on this table to interpret this value and create a date value based upon getdate() + the correct amount of days.  ( I am standardizing that a month is 30 days)

SELECT DATEADD( DD, 2, GETDATE() )     -- 2 days from today's date

SELECT DATEADD( WK, 1, GETDATE() )   -- 1 week from today's date

SELECT DATEADD( DD, 30, GETDATE() )  -- 30 days/1 month from today's date; 
                                                                               -- if you need next month then use DATEADD( MM, 1, GETDATE() )

SELECT DATEADD( DD, 32, GETDATE() )   -- 30 days/1 month & 2 days from today's date; 
                                                                                -- if you need "next month plus 2" days then use 
                                                                                --   DATEADD( DD, 2, DATEADD( MM, 1, GETDATE() ) )


If this is what you need then simply replace the “SELECT” statement with the variable/field assignment operation in your trigger.