Function FLOOR doesnt' work in SQL SELECT using Microsoft.Jet.OLEDB.4.0 RRS feed

  • Question

  • Hello everybody,

    I Have a little problem.

    I'm connected to a Access Db with provider Microsoft.Jet.OLEDB.4.0.

    I want to take the integer part of a numeric field to determinate in which interval belongs. The interval's length in the example is 100.

    I've written:


    SELECT  Field1, FLOOR (field1/100) AS Interval

    FROM Table1


    I receive this error:

    SQL's Executing error

    Error Source: Microsoft JET Database Engine

    FLOOR is not a definited function


    Probably, if i'd used Microsoft SQL Server I wouldn't have this problem. However...


    Thank in advance








    Monday, June 25, 2007 11:02 AM


All replies