Whole number pattern matching in Oracle 8i?

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 - 10:27:36 CST