Returning non whole numbers divisions.

[mwalsh]

I am looking for a way to return only the rows that have fractional numbers as the return to their division.  For example if untqty/units was a whole number I would want to eliminate it from the rows returned, but if it was a fraction then I would like it in the rows returned.

 

[karluk]

Which dbms are you using?&nbsp;&nbsp;Does it have the &quot;mod&quot; function?&nbsp;&nbsp;Mod(a,b) returns the remainder that a leaves when divided by b.&nbsp;&nbsp;If so you can use something like<br><br>select * from your_table where mod(untqty,unit) &gt; 0;