I am trying to SQL query for data changes of a table that has added to database log.
Compared to AX, SYSDATABASELOG is now changed that does not have separate fields storing old & new value.
the field [NEWDATA] seems to be storing a whole string of data, there is not more fields like [ORIGINALDATA]
How do I write the query for a certain field of a table that has changed & the old new value?
Example VENDBANKACCOUNT table.