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