>Have started to use the Merge command, and now want to use it with Output (For Auditing)
>I Can see examples of Deleted.* and Inserted.* but cannot see anywhere to capture Modified Columns
>
>Anybody got an example (of Output with Merge) where Inserted, deleted AND ALTERED columns are output ?
>
>Tia
>Gerard

New values (modified) are in Inserted and the original values (before the update) are in the Deleted tables.

In other words, SQL Server has only two virtual tables: Deleted and Inserted. In case of UPDATE, Inserted has new values (after update) and Deleted hold values before the update.