>Are you looking for the functions OLDVAL() and CURVAL()?
>
>>When the update-sql command is used to change a fields value and the table has an update trigger, is it possible in the trigger code to find out the original value of the field before the update was made? Thanks for the help.
>>
>>David

Thanks Nancy, that is exactly what I was looking for.