Are you just looking for any column is null or that all columns are null
or that specific columns are null or . what exactly do you need to
determine?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Scott Hamm [EMAIL PROTECTED] wrote on 10/02/2004 11:21:58 AM:
How do
I'm trying to find a null value anywhere in QA table.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 9:46 AM
To: Scott Hamm
Cc: [EMAIL PROTECTED]
Subject: Re: Looking for null values.
Are you just looking for any column is null
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 9:46 AM
To: Scott Hamm
Cc: [EMAIL PROTECTED]
Subject: Re: Looking for null values.
Are you just looking for any column is null or that all columns are null
or
that specific columns are null or . what exactly do you need
I think you would have to do one column at a time.
Like this.
Select * from QA where title is NULL;
Or you could get a little more crazy with something like this.
Select * from QA where (title is NULL) or (blabla is NULL) or (jimbob is
NULL) or (theskyisfall is NULL);
Donnny
-Original
Hamm'; [EMAIL PROTECTED]
Subject: RE: Looking for null values.
I think you would have to do one column at a time.
Like this.
Select * from QA where title is NULL;
Or you could get a little more crazy with something like this.
Select * from QA where (title is NULL) or (blabla