
November 24th, 2002, 09:53 PM
|
 |
Second highest poster :p
|
|
|
|
|
You can use NULL as per above, but sometimes i have had access not recognise a field as Null. The other problem happens when a user enters in a space in the field.
Using a combination of Len & Trim gives you something that will handle those cases.
SELECT
mytable.certainfield1,
mytable.certainfield2,
mytable.certainfield3
WHERE
Len(Trim(mytable.certainfield2))=0;
|