Hi,


|as_the_filter := StrToFloat(number1) + '>=' + FloatToStr(lo_nbr) +
| ' and ' + StrToFloat(number1) + '<=' + FloatToStr(hi_nbr);

That's not SQL syntax so it does not seems a fb question.

You try ruuning a simple sql command against fb and see if the result is not as expected. All, debug your app to find what is the actual sql statement it is sendind to fb.


Regards,
Anderson