Query creation problem

[Wernke zur Borg]

Hi,

I need to create a query to select certain objects with a condition like so:

    SELECT*FROM tableWHERE(col/16)=10;

|where the expression (col / 16) must be computed using integer division.

Column 'col' is defined as integer but the expression (col / 16) yields a 
floating point value, so the condition evaluates to false where it must not.

I tried using the expression parser with CAST and FLOOR operators but this is 
not supported.

|Any hints?

Thanks, Wernke



|
|