How to use wild cards with numbers

I am trying to get a list of customers based on zip code of GA. I am not getting any answers


FROM transaction_data

WHERE zip BETWEEN 300% AND 319%;

Please advise how

Did you try surrounding the wildcard in single quotes?
ex: '300%' AND '319%'

You can copy the zip INTEGER to another column of type VARCHAR and then query:

ALTER TABLE transaction_data

UPDATE transaction_data
SET zip_code = zip;

SELECT full_name, zip_code FROM transaction_data
WHERE zip_code BETWEEN '300%' AND '319%' OR zip_code LIKE '398%';

That returns correct answer for me.

No I have not tried that