>I believe that after an insert or a delete you can access that record again to compare values or do whatever with it. However I can't find anything in Books Online about how to get this information. I thought it was something like "select from deleted" or "select from inserted". It just doesn't work like this, so what I am missing? TIA.

The 'deleted' and 'inserted' aliases are only available from triggers. Also, don't forget that triggers aren't always fired once per record - those 2 virtual tables might contain more than one record.

Hope this help!