SQL REF? Function to return "Multiple of X"

j2112 · May 14, 2003

Goal:
Return all records where columnA is a multiple of 3.

Anyone know of an sql statement that will do this?

Thanks, j2112

MarcLodge · May 14, 2003

J2112,
How about something like:

SELECT COLCOUNT FROM SYSIBM.SYSTABLES
WHERE COLCOUNT/3 * 3 = COLCOUNT

Marc

sathyarams · May 15, 2003

Remember, here COLCOUNT is an INTEGER

Cheers

Sathyaram

More DB2 questions answered at

SQL REF? Function to return &quot;Multiple of X&quot;