Re: Syntax on Not null

[alicejwz]

Re: Syntax on Not null

Hi,

What is the syntax for not null in the where clause? I have a field(say,col_z) in the SQL Server table that stores bit value. I want to write a query to return all records in the table that are not null in col_z but I can't get syntax right?
I'm using AC2K & SQL Server 2K.
ms VB Error:
There was a problem accessing a property or method of the OLE object.
This works:
stg = "Select * from tblSampling_data Where disposition is null;"
These don't:
stg = "Select * from tblSampling_data Where disposition not null;"
stg = "Select * from tblSampling_data Where not(isnull(disposition);

Thank you!