FLOOR IN SQL

[Warrio]

Hello, I need to round a number to the 100 down.

Example, 25555 would be 25500.
I know the function FLOOR(25555, 100) in Excel

I wanted to know the equivalent in SQL.

Best regards

 

[Michel Walsh]

Hi,



Int( x / 100) * 100



Hoping it may help,
Vanderghast, Access MVP

 

[Van T. Dinh]

([YourNumber] \ 100) * 100

 

[Warrio]

It works perfect,

Thank you

Hi,



Int( x / 100) * 100



Hoping it may help,
Vanderghast, Access MVP