Agnes,

My tests with VFP6 show that *none* the syntaxes below work correctly. They retrieve the isblank() or empty() value from the current record at the time the query begins. IOW, if you are sitting on the 1st record when you run the query, and it is empty() on that field, it will show that all the records are empty.

But if you leave off the table name (isblank(cField)), it works correctly.

>Hi Jim,
>
>>I'm not sure I see what the problem is...
>
>Lets see if I can make it more clear.
>The problem is within a larger view with 5 source cursors. I guess it is to tricky to understand.
>My example reproduces the problem.
>
>It happens only with the combination of ISBLANK() and the use of AS in the FROM (or JOIN) clause
>

>SELECT;
> ISBLANK(Cur1.cField);
> FROM aTable AS Cur1
>

>
>Code like
>

>SELECT;
> EMPTY(aTable.cField);
> FROM aTable
>

>or, for example
>

>SELECT;
> EMPTY(Cur1.cField);
> FROM aTable AS Cur1
>

>works perfectly.
>
>>
>>I wouldn't expect CUR1 to be 'available' until the result set is to be written. ...
>Cur1 is a temporary Alias, available only within the SELECT SQL.
>
>> ... Don't you really want aTable.cField in the field list?
>? I dont understand this question.
>
>
>Agnes