I designed a query to display results in which the zip code (text format) is within a zipcode range in another table. for particular range (see below) I am getting wrong result.
Ex : zip code 60025 is coming between 6000 and 6099.
it is greater than equal to 6000 - OK
It is less than equal to...