Re: Whole number pattern matching in Oracle 8i?

Interesting use for "modulus".

Personally I'd use the following in my where clause:

WHERE
   trunc(data) = data

JP

"Darren Fish" <dfish3_at_ford.com> wrote in message news:<a7aiqd$16537_at_eccws12.dearborn.ford.com>...
> Try using mod(number, 1) = 0
>
> The modulus (remainder) of a whole number (or integer) is always 0.
>
>
> "Keith Lee" <cmarvel_at_cts.com> wrote in message
> news:3c98b65e.14951719_at_nntp.cts.com...
> > All:
> > I am attempting to do a total count on a database table's information.
 I am counting on a whole number based on
> > whether two other numbers are equal or not. These other numbers are of
 the definition number(5,2). I trying not to
> > count the numbers that aren't a whole number. That is if the data were:
> >
> > 1
> > 1.2
> > 2
> > 2.4
> > 2.5
> > 3
> >
> > Here I am trying to count only the numbers 1, 2, 3. How would I do that
 in Oracle 8i Personal Edition?
> >
> > Keith Lee
Received on Fri Mar 22 2002 - 20:06:56 CET