Hi!

FYI, empty() in VFP return .F. for NULL values, that will work incorrectly in the sample you represented.

>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