<div>
you can only do this in the sql view of the query<br />
<br />
select * from ContactPhone <br />
where &nbsp;right([ContactPhone ].[Work_Phone],4)=right([o<wbr />nlyDCS].[W<wbr />ork_Phone]<wbr />,4)
</div>


you can only do this in the sql view of the query

select * from ContactPhone
where  right([ContactPhone ].[Work_Phone],4)=right([onlyDCS].[Work_Phone],4)

<div>
<div class="content wysiwyg-content">
I have the following SQl query I'm running against two tables in an Access 2007 database:<br />
<br />
<b>SELECT ContactPhone.Item_ID, ContactPhone.Last_Name, ContactPhone.First_Name, ContactPhone.Work_Phone, ContactPhone.[1st_Choice],<wbr /> ContactPhone.[2nd_Choice],<wbr /> ContactPhone.[3rd_Choice],<wbr /> ContactPhone.Comments<br />
FROM ContactPhone LEFT JOIN onlyDCS ON ContactPhone.Work_Phone=on<wbr />lyDCS.Work<wbr />_Phone<br />
WHERE (((onlyDCS.Work_Phone) Is Null));</b><br />
<br />
I want to just use a substring compare of the last &nbsp;four character of the &quot;Work_Phone&quot; from both tables.<br />
<br />
example of the Work_Phone &nbsp;data<br />
<br />
555-1234<br />
<br />
just need to compare<br />
<br />
1234<br />
<br />
Thanks!!
</div>
</div>


I have the following SQl query I'm running against two tables in an Access 2007 database:

SELECT ContactPhone.Item_ID, ContactPhone.Last_Name, ContactPhone.First_Name, ContactPhone.Work_Phone, ContactPhone.[1st_Choice], ContactPhone.[2nd_Choice], ContactPhone.[3rd_Choice], ContactPhone.Comments
FROM ContactPhone LEFT JOIN onlyDCS ON ContactPhone.Work_Phone=onlyDCS.Work_Phone
WHERE (((onlyDCS.Work_Phone) Is Null));

I want to just use a substring compare of the last  four character of the "Work_Phone" from both tables.

example of the Work_Phone  data

555-1234

just need to compare

1234

Thanks!!

Compare only last 4 characters of phone number in SQL query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.