We are working on SQL Server version 7. We have requirement of moving the
old record from Original table to Audit table on any modification, by using
SQL Server Trigger.

In the Original table we have columns of Data type 'Text'.

When we try to Create triggers by selecting data from 'Deleted' table and
Insert into Audit table, we get following error
"
Server: Msg 311, Level 16, State 1, Procedure Trig_T13_Upd, Line 5
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted'
tables. "

In the SQL Server help, it has been given that we have to join the Original
table with 'Deleted' table for selecting the column with data type 'Text'.
" To retrieve the new value in either an INSERT or UPDATE trigger, join the
inserted table with the original update table. "

This gives me only NEW value entered on Text column and not the PREVIOUS
value.
For example in the 'Text' Data type column,
If the old value is NULL and I modify with a value 'temp'.
I could get only 'temp' and not NULL value.

Is there any way to select by using TRIGGERS, the old value for columns with
Data type 'Text'?