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.