comparison on text field

my query: select * from inventory where ModelRef=' '
but, the result includes all records that having blanked ModelRef field.
I want to know what setting controls this behavior.
Thanks,
LeonardHi
You may want to look at using NULL instead of empty strings.
John
"Leonard Poon" wrote:

> my query: select * from inventory where ModelRef=' '
> but, the result includes all records that having blanked ModelRef field.
> I want to know what setting controls this behavior.
> Thanks,
> Leonard
>
>