Empty Field - How is this recognised?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a field in a table which has not had anything
inserted into it (obviously it's not a primary key but it
is a foreign key) - it's called TASK_NAME.
I need to identify the TASK_NAMEs which have not yet been
set.
I've tried in a number of ways (TASK_NAME=''etc. type
thing) but no luck.
Can anyone help?

Thanks in advance.
 
A field which has never had a value in it would contain a Null. A field
with a previous value, now erased, would have a zero-length string. These
are not the same. You'd have to test for both, I'd guess.
 
In a query, you would use is Null as the criteria.

Field: Task_Name
Criteria: Is Null
 
Back
Top