I know that to check for NULL in a SQL field, certain code is required. Is that what I am missing? And if so, does anyone know the specific code? Thanks.
I am accessing the Active Directory database, so
Department is a
varcharfield. Basically I want to make sure the strFilter contains a department filter. If the user doesn't input one, I want to make sure the department field is not null. So...
Code:
If InStr(1, strFilter, "department", 1) = 0 Then
strFilter = strFilter & " AND Department <> """
End if
Andy
AIM: LoPrestoAtWork
Trusant Technologies, LLC
NULL checker?
