Joining Different Data Types

I have a column in my database that is being registered as a string because it’s a number prefixed with a character. I’m trying to do a join with this table, but can’t because of the character. Is there any way to make this join work? For example I would like to join “e5678” to “5678”.

Hey Zachary!

Yes, this is possible with Calculated Joins! For this example you can use a formula on the join key to make sure they match – I believe this formula will work out for you.

Right(Text([column]),4)