selecting records on empty int field

Hi,

I want to select records having an empty int field. I probably should
change that field to not-empty by default, so I have to at least give
the value 0 to it. Until then I don't know how to select it:

select lidnr from hvw where naam != " " and kenmerk2006 != ' '

where naam = char and kenmerk2006 = int doesn't work.

Thanks for helping out.

Huub

On 26.04.2007 11:41, Huub wrote:
> Hi,
>
> I want to select records having an empty int field. I probably should
> change that field to not-empty by default, so I have to at least give
> the value 0 to it. Until then I don't know how to select it:
>
> select lidnr from hvw where naam != " " and kenmerk2006 != ' '
>
> where naam = char and kenmerk2006 = int doesn't work.
>
> Thanks for helping out.
>
> Huub

Try

WHERE your_field IS NULL

robert

> Try
>
> WHERE your_field IS NULL
>
> robert

Working. Thank you.