I am trying to do this:
Select <fields>
from table
Where cast(field1 as int) > <low int value>
and cast(field1 as int) < <high int value>
I am using self servicing and I cant quite make out how to do this. The documentation is a little confusing.
I thought I would do something like this
filter.add(new dbfunctioncall("cast({0} as int)", someentityfields.field > iLowValue
but then I am not sure how to complete it to test for the high value...
Could someone please explain to me how do this?
Thanks
