Simple SQL one

[a2427]

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

[Surgeon]

Something like this maybe :

SELECT *
FROM tblName
WHERE (Not fieldName Is Null) OR (fieldName<>"");

Surgeon