>>>>>
>>>>>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>Again, as long as we're being precise, the definition of redundant is something that is repeated unnecessarily, while the definition of superfluous is just something that is unnecessary.
>Yes, they are synonyms, but superfluous is more precise.
I agree.
"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