SELECT * From MyTable WHERE LEN(RTRIM(MyField))>0>So far, when having the need to get all records where a specific field is not empty, I was using something like this:
>SELECT * From MyTable WHERE LEN(ALLTRIM(MyField))>0 >>
>SELECT * From MyTable WHERE MyField>"" >>
>SELECT * From MyTable WHERE MyField>" " >>