I guess you may have to use SQLTemplate for this. On May 31, 2011, at 5:26 PM, Wernke zur Borg wrote:
> 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 > > > > | > | > >
