Searching for an empty/non-empty field

[jda]

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).

Thanks,

Jon