Re: between '' and 'ZZZ'

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 2000/03/30
Message-ID: <8bvm86$i25$1@ctb-nnrp1.saix.net>#1/1

Leo Baltus wrote in message <8bvje3$mn9$1_at_nnrp1.deja.com>...
>This is probably a newbe question, but anyway:
>
>Can somebody please explain the following :
>
>select * from table where col1 between '' and 'ZZZ'
>
>it gives no result, but when I try:
>
>select * from table where col1 between ' ' and 'ZZZ'

I think it is because the first SQL means this:

select * from table where col1 between NIL and 'ZZZ'

NIL (or null) is not in any range - it a null, nothing, void.

regards,
Billy Received on Thu Mar 30 2000 - 00:00:00 CST