I need to know how to say [Field]=Null or [Field]="" in a query. My problem is, I'm creating dynamic Filter strings using string concatenation of different fields to filter on (User enters Field, Operator, Data in a form and another form is filtered on this data), so if it is simply [Field]="" I can't have a string which is "[Field]=""".
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL null
- Thread starter iainm
- Start date
LittleSmudge
Programmer
I think what you mean is
IsNull(FieldName)
As in
"SELECT * FROM tblName WHERE IsNull(ThisField);"
'ope-that-'elps.
G LS
IsNull(FieldName)
As in
"SELECT * FROM tblName WHERE IsNull(ThisField);"
'ope-that-'elps.
G LS
- Status
Similar threads
- Locked
- Question
