>>

>>select * from MyTable where LEN(rtrim( MyField) ) > 0
>>

>>
>>Is the above efficient method or there is a better approach?
>>
>>I don't know if there is a better approach or not, but to make it more robust, you should modify it like so:
>>
>>

>>select * from MyTable where LEN(ltrim(rtrim( MyField)) ) > 0
>>

>
>I thought about this too. But I thought that the "ltrim()" would be redundant. Can you think of a case where the rtrim() by itself will not work?

I think that Marcia is using a construct that we XBase programmers used before ALLTRIM or EMPTY came on the scene.
As long as we're being precise, though, let me point out that ltrim is not redundant. It's superfluous.
"Redundant" implies that it does the same thing that rtrim does. It doesn't.
However, in this situation it is superfluous.