What changed from the previous row

Our ERP has a bunch of Audit tables... a record/row is created each time something changes in (for example) the Part Master file.
When a change is made, an audit table row is created containing the values of all of the columns as the production table plus the transaction date, transaction time, and user.
To know what "changed", you have to compare it to the previously created audit row.

I'm trying to figure out how to recognize the column(s) that changed versus the previous row of data, using SQL.
I know how to do this in an RPG program, but have yet to come up with an SQL equivalent.

Any ideas?
TIA
Greg
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>