Case Sensitive Inner Join

[Rriemer]

I need to update records in one table with info from another inner joined by an ID field which is case sensitive. Additionally i need to drop the last three digits from the ID on one table.

I used this select query to test and it is not working, any ideas?

SELECT Copy_All_Amhsi_combo.acct_id, jn179238.sfaccid, Copy_All_Amhsi_combo.VIS_N, jn179238.idnumber
FROM JN179238 INNER JOIN Copy_All_Amhsi_combo ON Copy_All_Amhsi_combo.acct_id = left(jn179238.sfaccid,15)
WHERE Asc([Copy_All_Amhsi_combo].[acct_id])=Asc([jn179238].[sfaccid]) ;

[June7]

Asc() function can act on only 1 character. Example:

Asc("a") returns 97

Asc("abc") also returns 97

Did you try without the WHERE clause?

Review https://support.office.com/en-us/art...rs=en-US&ad=US

[Rriemer]

Yes I tried a few different ways. Honestly the asc i believe wont work because the string is 15 characters and the change of case could be anywhere. (Note: I am joining on Salesforce ID's)

[orange]

research compare binary http://www.bettersolutions.com/vba/V...I521230882.htm