Max Value from Zero (Positive or Negative) Help

You can use the ABS function to calculate the absolute value and use that MAX value:

MAX(ABS(TABLE1.A - TABLE2.B))

---

Dan Guzman, SQL Server MVP, http://www.dbdelta.com