Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I have a simple query with a SELECT a.Field from DE WHERE a.Field NOT LIKE '%Control%' and I'm getting a different number than when I filter the same data extension with the filter not contain 'Control'. Any idea why?
The issue was that the field had some records empty and with the filter those records where counted but with the WHERE a.Field NOT LIKE '%Control%' those empty fields where excluded