[BUG, Ivan] Searching for an empty/non-empty field

[Frank Schima]

On Nov 11, 2004, at 12:59 PM, jda wrote:

>>
>>  > One more little problem, then.
>>>
>>>  I tried
>>>
>>>  SELECT hit from thereferences WHERE title IS NULL
>>>
>>>  on an empty db and got no match...
>>
>> Did not catch.
>>
>> If db is empty. The all right. No match
>>
>
> Sorry, I shouldn't have written empty. My databases always have one 
> record -- I meant that this record had no entries in any field. So 
> title IS NULL, but I didn't get a hit.

Jon, just to be clear. NULL is different than empty for a text field. 
Are you sure the field is not simply empty?


Best regards,
Frank Schima