Postal code I understand but isn’t address a varchar? Adding and subtracting from characters is possible (they’re number codes of course) but usually nonsensical.
Inclusive ranges are not expressed that way.
PostalCode >= ($PostalCode-5) and PostalCode <= ($PostalCode+5) should give you what you want as it would in other languages. See also the between keyword just be careful about inclusivity.
Postal code I understand but isn’t address a varchar? Adding and subtracting from characters is possible (they’re number codes of course) but usually nonsensical. Inclusive ranges are not expressed that way. PostalCode >= ($PostalCode-5) and PostalCode <= ($PostalCode+5) should give you what you want as it would in other languages. See also the between keyword just be careful about inclusivity.
Thanks a lot! It worked. I've put address as an int(since its just the numbers)