>Anyone know how to
>only select the non-empty field from the record. The record already is filtered from the whole table.
>
>Thanks

select ... from ... where myfield <> ''

An index on MyField will help performance