>>Specifically what I am trying to do is in the delete trigger of a
>>particular table copy some of the data to another table for archiving
>
>Does it work using something like this:
>
>INSERT INTO save_table (col1, col2)
> SELECT column1, column1 FROM deleted
>
>-Mike

No becuase in 7.0 any field defined as a text field cannot be accessed from
'deleted' or 'inserted'

The code you show is what I was using in 6.5


Jacob