SQL联接表 - 加入最后四位列数

Question

我正在尝试在SQL中加入两个桌子。我想将电话号码的最后四位数字与第二列的A列一起加入，其中仅显示最后四位数。

From ExcelSheet1 E
Join Walkers W
ON W.Lastname = E.LNAME
AND W.Firstname = E.FNAME
and W.PhoneNum like '%'+E.MEMBER_NUM

Answer 1

From ExcelSheet1 E
Join Walkers W
ON W.Lastname = E.LNAME
AND W.Firstname = E.FNAME
and W.CardNum like '%'+ cast(E.MEMBER_NUM as varchar)

将变量成员_num作为varchar施放后，我得到了我正在寻找的结果