Sergey, Thanks. --Ken

>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 >