Our SQL database table has a field which contains the street address --(usually a number followed by the street name though it's just a text string and it could contain anything. If the field doesn't start with a number then I'll just skip that record).
I need to determine if the street address number is even or odd. I only want to select the odd street addresses (or maybe it's the even ones I want, I forget :-)
How would I go about parsing off the street number and then testing to see if it's an even or odd number?