Helpful Information
Home
Categories
Contact us
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)