Query operator 'Does Not Begin With' omits blank values in query results

When using the query operator 'Does Not Begin With' on fields with text values, blank results are omitted.

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Alternate Solution

In The Raiser's Edge 7.93, use a query criteria as follows if 'Does Not Begin With' needs to consider blank values:

(<field> does not contain <enter your text>
OR <field> blank)

Example: 
(First Name 'does not contain' Jane
OR First Name is blank)

Environment

 7.93
 7.93.5782, patch 8

Was this article helpful?