Filter field having decimal values only

[pratibha14]

Hi,

I have a field named Qty which can have decimal values as well. I want to filter records where qty is in decimal (not int)

I did as follow:
select qty from table where qty like '%'||'.'||'%'

but i think this makes query slow. Is there any in-built functio (or any other way) to fetch deciaml records only?

Thanks.

 

[ChrisHunt]

How about...

SELECT this,that,the_other
FROM   my_table
WHERE  qty != TRUNC(qty)

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd