Re: Whole number pattern matching in Oracle 8i?

From: Darren Fish <dfish3_at_ford.com>
Date: Wed, 20 Mar 2002 13:02:16 -0500
Message-ID: <a7aiqd$16537@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 Wed Mar 20 2002 - 12:02:16 CST