Assuming your table is called MyTableName (referred to twice below). If you run

with MySelects(selectstatement)
as(
select 'select '''||rdb$field_name||''' as MyNullFields from rdb$database where exists(select * from MyTableName where '||rdb$field_name||' is null) '
from rdb$relation_fields
where rdb$relation_name = 'MyTableName')
select list(SelectStatement, ' UNION ')
from MySelects

and then run the result, then you should get a list of fields that has one or more NULL occurrences.

Note that the intermediate select can be quite long, but I hope not too long for Firebird.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of rockyoh73505
Sent: 13. januar 2011 08:27
To: firebird-support@yahoogroups.com
Subject: [firebird-support] about null...

I have table with 50 field and mnay of the field is empty(i.e. null).
I am wondering is ther query to find me the column that is null??? or is there any other way to do so??

I appreciate your help...