At 04:09 AM 25/09/2005 +0000, you 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?

The SQL definition is the one.
BETWEEN X AND Y means
VALUE >= X and VALUE <= Y

./heLen