Hi,

if u have no idea about x, y order
then use:
...
(Myfield Between X and Y OR Myfield Between Y and X)
...

Rgrds.

-Ali

--- In firebird-support@yahoogroups.com, "jebem_ti_registraciju"
<jebem_ti_registraciju@y...> wrote:

> Why there is a difference between (BETWEEN 3 and 8)
> and (BETWEEN 8 and 3)?
> Does SQL standard EXPLICITLY SAYS
> BETWEEN X AND Y means
> VALUE >= X and VALUE <= Y
> or
> VALUE >= MIN(X, Y) and VALUE <= MAX(X, Y)
> or it just says (BETWEEN X AND Y)
> means between x and y?