>>>To use seek you need to index the table on the field in question. Then I believe you can do:
>>>
>>>seek !empty(myfield)
>>
>>Nope.
>>This wouldn't work because the expression must match the index expression.
>
>So what is the answer then?
Whoops -- cut off a bit :)
You had also suggested LOCATE, that works fine.
Insanity: Doing the same thing over and over and expecting different results.