How to use wild cards with numbers

Get Help SQL
,
#1

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

SELECT *

FROM transaction_data

WHERE zip BETWEEN 300% AND 319%;

Please advise how

#2

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

https://learnsql.com/blog/sql-wildcard/

#3

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

ALTER TABLE transaction_data
ADD COLUMN zip_code VARCHAR;

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.

#4

No I have not tried that