@query=54321
654321 or
543210

but you will not find
54320 for example

##</code><code>##

select min(abs(zip-@query)) from zipcodetable 

##</code><code>##

-----------------------------------
--the good, the bad and the physi--
-----------------------------------