Multiple of 100, 1000

jweir · Post by **jweir** » Wed Sep 04, 2013 1:45 pm

Hello,

I have a requirement to check if a column is a multiple of 100 or 1000. Is there a simple way of doing this?

Also, I am using Netezza, so if there is a Netezza function that does this, please let me know. I have searched but came up empty.

Thanks in advance.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Sep 04, 2013 1:48 pm

Divide by 100, if there's no remainder you are good.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 04, 2013 2:14 pm

Code: Select all

Mod(InLink.TheColumn, 100) = 0

chulett · Post by **chulett** » Wed Sep 04, 2013 2:15 pm

MOD() the field by 100 or whatever... if the answer is zero there's no remainder and thus evenly divisible.

jweir · Post by **jweir** » Wed Sep 04, 2013 3:31 pm

MOD works perfect. Thanks guys.