I want to to select all records from a table where a field is not null or is not a zero length string.
SELECT * From tblTable Where fldFieldName = <<what goes here>>
thanks
Printable View
I want to to select all records from a table where a field is not null or is not a zero length string.
SELECT * From tblTable Where fldFieldName = <<what goes here>>
thanks
Something like this maybe :
SELECT *
FROM tblName
WHERE (Not fieldName Is Null) OR (fieldName<>"");
Surgeon