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
>

>
>>Is there any function in SQL 7 that works like VFP EMPTY(). OR can I create one that I can use in a select statement.
>>
>>I have been doing this:
>>
>>Select * from Table
>>where Field1 is not null and
>>field 1 <>''
>>
>>Hope I can do this:
>>
>>Select * from Table
>>where not empty(Field1)
>>
>>Thank You
>>Miles