Sql Server Change Column Value On Insert Trigger

How do I change values of a column in an insert trigger ? In Oracle I can use the following code to change the col1 value to upper case in an INSERT Trigger. How do I do it in SQL

Solution 1:

Here is one way using an INSTEAD OF trigger.

CREATE TRIGGER MyTrigger ON MyTable INSTEAD OF INSERT AS
    INSERT MyTable(col1, [other columns])
    SELECT UPPER(i.col1)
        , i.[other columns]
    FROM Inserted i