Searching for an empty/non-empty field

[Frank Schima]

Hi Jon,


On Nov 11, 2004, at 7:50 AM, jda wrote:

> Does anyone know how to search for an empty/non-empty indexedByWords 
> field in v2? The obvious (to me, anyway) solution:
>
> select * from theTable where myField=''
>
> doesn't work.
>
> I also need the converse (searching for a non-empty field).

Try this:

    select * from theTable where len(myField) = 0

and the converse would be:

    select * from theTable where len(myField) > 0

Both cases would (should) skip Null values.


Best regards,
Frank Schima

p.s. Please don't reply to an unrelated post because Mail sees it as a 
thread! :^)