How would I query a odd (or even) street addresses only for a specific street?
S Steve H Apr 26, 2005 #1 How would I query a odd (or even) street addresses only for a specific street?
M MGFoster Apr 26, 2005 #2 Steve said: How would I query a odd (or even) street addresses only for a specific street? Click to expand... ODD: SELECT Address FROM Addresses WHERE (HouseNumber Mod 2) = 1 EVEN: use (HouseNumber Mod 2) = 0
Steve said: How would I query a odd (or even) street addresses only for a specific street? Click to expand... ODD: SELECT Address FROM Addresses WHERE (HouseNumber Mod 2) = 1 EVEN: use (HouseNumber Mod 2) = 0
