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