I have a query which contains this line:
ON t1.SSN = right(t2.SSN, len(t2.SSN) - 1)
t1.SSN is now being changed to SSNLast4, which will contain the last 4 of the SSN instead of the entire SSN. So, how do I change the code on the right of the equal sign accordingly?
I'm trying to say "ON t1.SSNLast4 = Last4 of t2.SSN"