Hi All,
there is a condition in a query where i have to check for a char field is NULL or not.
how do I do it ??
select count(*) into count1 from DFKKOP
WHERE blart = 'CO'
AND betrw < 0
and augbl is NULL.
the field 'augbl' is a char type field. when i write the above query, it gives me a incorrect result. actually i want to retrieve the field(augbl) where the field value in the table DFKKOP is a space.
plz tell me how to write the query in this case.
thanks..
prad