Bug
The NOT LIKE SQL operator for definition queries incorrectly selects null values in ArcGIS Pro when query expression is in the form NOT LIKE %xxxxxx%.
| Bug ID Number | BUG-000128794 |
|---|---|
| Submitted | February 19, 2020 |
| Last Modified | June 13, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.5 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | As Designed |
Additional Information
As per standard SQL specifications, NULL values need to be treated separately. Use the following SQL instead: TEXT NOT LIKE '%Test%' OR TEXT IS NULLWorkaround
Use the syntax ('Test'). The modulo operator allows all instances of 'Test' to be excluded, including 'Test' as part of the phrase 'NotTest.' The ('Test') syntax will only return 'Test,' which may not be a viable solution for all users.'
Steps to Reproduce
Bug ID: BUG-000128794
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App