Well your select will find any number which contains your @query. So you will find

@query=54321
654321 or
543210

but you will not find
54320 for example
[download]

but when it's only numerical zip maybe the following will work:

select min(abs(zip-@query)) from zipcodetable
[download]

-----------------------------------
--the good, the bad and the physi--
-----------------------------------
[download]