Lempster (4/4/2014) Phil Parkin (4/4/2014)
You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address columns you are interested in and then compare the checksum of the source columns to the checksum of the destination columns; if the checksum values are different then at least one of your source columns has changed.
Disclaimer: I am not connected to Konesans in any way.
This is a good solution. For good performance, you should consider persisting the checksum as a new column in the target table(s).
Absolutely Phil, hence I stated '..calculate and store...';-)
I should have read your post more carefully! The lure of the Friday-afternoon beer is already proving distracting
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.