PB8 and between SQL clause failure

[brodyToo]

Hi:

We're looking at migrating to PB8 from 6.5, and have converted our current app, and are testing it.

On one of the datawindows, we have an SQL statement that (to paraphrase) looks like: amt > 5.00 and amt < 20.00.

This consistently fails.

It also fails if we use the form: amt betweeen 5.00 and 20.00.

Equality checks (=5.00 and > 4.00) or (< 4.00 and = 2.00) return good results.

Any clues?

Thanks,

BrodyToo