between '' and 'ZZZ'

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'

(the difference is one space in the 1 argument) I get the result set I expected.

--
--

Leo Baltus leob_at_isdc.nl
ISDC, Hilversum , The Netherlands

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 30 2000 - 00:00:00 CST