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