Skip to Content
0
Former Member
Nov 24, 2006 at 03:38 PM

tracking NULL values

62 Views

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