Helpful Information
 
 
Category: Firebird SQL Development
Sql statement to select a null field

Hi Group

Here is the sql statement :

select DocNo,DocDate,BillNo from table where billno.isnull

I know the billno.isnull is not allowed in the statement , but I how do I overcome this?

Thx

I finally found the answer ,just to share :

select DocNo,DocDate,BillNo from table where billno Is Null

to select not null rows fronm the table










privacy (GDPR)