You should be able to get this to work, but you need to think backwards.
Try something like this:
select ..... where 1 = (mod(colname,50))
Remember you want to look at the mod of the col value and find the results
that equal 1.
Troy Sosamon
-------- Original Message --------------
hello, i have a table, and for paging reasons, i want to get every entry
where:
count modulus 50=1
and
count modulus 50=0
this would make it so i could make a drop down list that had ranges like:
1..50
51..100
101..150
etc.
problem is i cant find how to do modulus in SQL. Is there a way? If not is
there another way to do this without a for loop?
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
