that is interesting, why is it 1 = instead of = 1? Will it run faster that
way?
----- Original Message -----
From: "Troy Sosamon" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 12:39 PM
Subject: RE: Witango-Talk: modulus
> 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
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
