>>>
>>>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.
Redundant and superfluous are synonyms.
http://www.merriam-webster.com/dictionary/redundant
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham