various ideas to ponder (not all inclusive):
1. there is no single 'operator', you must make two requests (new record/request) for this to work.
enter find mode
set field gender; "Male"
set field gender; "="
You can test this manually, as well as scripted.
The new record/request turns this into an OR search.
2. In this instance if you ONLY have the three possibilities:
then you can think "reverse" and find "Male" or empty, by doing a Find "Female" and omit, but that's probably confusing to users manually.
3. There is also the Expand find request, however with multiple fields to search, this could even be more complex.
If you are having user enter values to "search", capture them (into variables, perhaps?) and think about the OR method above. With multiple fields, I'm not sure this would get you accurate results.
4. another idea is the ExecuteSQL function which could do a slick combination of AND with OR in the WHERE clause.
(x=var1 AND y=var2) OR (b=var3 OR b IS NULL) <--- just some examples that may not match your needs
So many possibilities.
I think the operator that your searching for - is just plain 0' in your primary key field - this will start by finding all the records - anything you add in terms of find criteria alongside that will just reduce the number of records found. In this case, a blank field in a find will have no effect, which it the effect I think you are looking for.
Best wishes - Alan Stirling, London UK.
Alan, I don't understand.
Are you suggesting the string of characters zero (0) and apostrophe (') ?
This doesn't work.