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