Solved MsSQL Integration only works with "Direct Match"

[LEAD]

I am running into issues where the MsSQL Integraion will only work when there is a direct match on the phone number. If the phone number is off by 1 character it fails. My SQL query is working and pulling the correct results, but the integration is not working and throwing the following error:
"CRM Integration is working OK but contact number does not exist. Check log for more info or try a different number."

 

[LEAD]

And yes I did go into the contacts and set the digit match to less than the phone number. I even set it to 1 and that didn't work.

 

[LEAD]

I realized the error in my ways, It does matching starting with the last digit. So if i entered 123456789 as the search it would work. This can be closed/deleted