Update odd or even records

[kristinac]

I need to update address records based on whether the address is odd or even. Is this possible? I have not found the syntax. Basically I want to say:

UPDATE Addresses
SET StreetId = 2
WHERE StreetId = 3
AND Address >= 1
AND Address <= 4197
AND [Address is ODD]

Is this totally ridiculous or possible?

Any help would be appreciated. Thanks!

 

[Golom]

Assuming that "Address" is numeric
[blue][tt]
UPDATE Addresses
SET StreetId = 2
WHERE StreetId = 3
AND Address >= 1
AND Address <= 4197
AND Address MOD 2 = 1
[/tt][/blue]

 

[kristinac]

Thanks very much Golom! I was working with MOD but I had the syntax all wrong.

Thank you!