How do I find out whenever a value changes in a certain column?

Need help if anyone can offer!

I currently have my select statement returning the TOP 1000 * results from a table. They are CC numbers that are currently active. I’d like to see how I can go about writing a query that could show me what has CC numbers have changed.

If something has changed, it will send a report to the listed people. If nothing, then it does nothing. It only actions once something has happened. We have an inhouse system that will do the automated part… I just need a select statement that will return what has changed. If I can get some help on this, it would be amazing!

Thank you!