Thread: Finding values in a column that are multiple of 4

n % 4 == 0 implies n is a multiple of 4.

You could do this with an EXEC SQL UPDATE statement. No need to write a program.

Todd

Sure. Send me a link to your SQL Reference manual for the platform you are using.

WAG:

Code:

update my_table set mult4='Y' where mod(cc, 4) = 0;
update my_table t set mult4='N' where mod(cc, 4) != 0;

or maybe

Code:

update my_table set mult4 = case when mod (cc, 4) = 0 then 'Y' else 'N';

That's from Googling stuff. I have no idea if it's right.

I see that you have two choices.

You can create an expression like

Code:

EXEC SQL UPDATE ... SET mult4 = 'Y' WHERE  ((cc/4)*4)=cc ;

The above assumes your database manager uses integer division for smallints. You can research that.

Or you can use mod()

Code:

EXEC SQL UPDATE ... SET mult4 = 'Y' WHERE mod(cc,4) = 0 ;

That's my quick interpretation of the syntax.