Skip to content
Advertisement

MS Access SQL – Find numbers with decimals no end to Zero (,00)

I am having a table and i would like to find all numbers where it doesn’t end to ,00 but with decimal number like ,01 or ,23 or etc…

I would like to create a sql query to create column c like

iif(s IS ZERO AFTER DECIMAL, NULL, s)

Is it possible in MS ACCESS SQL?

Advertisement

Answer

For positive numbers, you can use floor or int():

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement