I recieve data where I am comparing zip codes from raw data, to a zip code table. The columns I am matching are in integers.

The issue is that in the raw data, sometimes the zip code is extended to more than the 5 characters in the zip code table so I am getting null value returns

A sample of this is in the raw data is:

Zipcode
54303
54304786
78641

Is there a way I can have it compare only the first 5 digits of the zip codes in the raw data zip code column to the zip code table? Or would I have to convert the data type? Or alter or truncate the characters somehow? If so, please include how to do this. Any help would be greatly appreciated. Thank you!