Avoiding Decimal Places in the query

Database
Enthusiast

Avoiding Decimal Places in the query

Hi,

I have values like this in a column

FC_cost

0259.00167
0145.98487
45678974
456464646454
564674467767
1254.67677

i want to select only values like this

FC_cost

45678974
456464646454
564674467767

I have tried like this in the sql assistant

sel * from table where fc_cost not like '____.'

sel * from table where fc_cost <> '%.'

But i am getting the decimal values also.

Please tell me how i can ommit the decimal values and take only non decimal values
3 REPLIES
Junior Contributor

Re: Avoiding Decimal Places in the query

Hi moras,
try this:

WHERE FC_cost MOD 1 = 0

Dieter
Enthusiast

Re: Avoiding Decimal Places in the query

Hi Dieter,

i tried this WHERE FC_cost MOD 1 = 0, but this is not working....

can u tell me someother way to do the same.

it will be very helpfull.
Enthusiast

Re: Avoiding Decimal Places in the query


can you try

WHERE FC_cost = FC_cost(INTEGER)