Thanks for your replay.

If you see null with ibexpert, how come this data can be store in Firebird, since ddl for this column not allow for null value? Could it be a bug in Firebird?

Another strange results when issued this statement

SELECT * FROM M_INT_FRM a
where a.id_div_lc is null

It will returns 3 result (via flamerobin).

Thanks and regards,
Sugiarto

> I have tested your database and i think is an error of flamerobin, what you
> see 0 i see null with ibexpert. try
>
> SELECT * FROM M_INT_FRM a
> where a.ID_TRS_TYP = 100
> and a.id_div_lc is null
>
>
>
> May be in sometime you have changed the column from null to not null.
>
>
>
> Regards, Jesus
>
>
> [Non-text portions of this message have been removed]
>