No it's not. I don't know about DB/2 but in Oracle I think it will look like this

 Select * from Table
 where LENGHT(RTRIM(NVL(Field1, ''))) > 0

>Sergey,
>
>PMFJI, but is the syntax you present cross-platform? Will it run on DB/2 and Oracle?
>
>Thanks...
>
>>You can use

Select * from Table
>>where Field1 is not null and LEN(RTRIM(Field1)) > 0
>>   or
>>Select * from Table
>>where LEN(RTRIM(ISNULL(Field1, ''))) > 0
>>

>>
< SNIP >