'Y' AND (CUSTOMER_ID NOT LIKE '4570*' OR CUSTOMER_ID <> '1604002' OR CUSTOMER_ID <> '3708001')" T" /> 'Y' AND (CUSTOMER_ID NOT LIKE '4570*' OR CUSTOMER_ID <> '1604002' OR CUSTOMER_ID <> '3708001')" T" /> 'Y' AND (CUSTOMER_ID NOT LIKE '4570*' OR CUSTOMER_ID <> '1604002' OR CUSTOMER_ID <> '3708001')" T"/>

VB.NET DataView RowFilter - multiple conditions - 'NOT LIKE' condition is not filtering

267 Views Asked by At
dvShipList.RowFilter = "ASNNEED = 'Y' AND ASNFLAG <> 'Y' AND (CUSTOMER_ID NOT LIKE '4570*' OR CUSTOMER_ID <> '1604002' OR CUSTOMER_ID <> '3708001')"

The DataView RowFilter is working with the exception of "CUSTOMER_ID NOT LIKE '4570*'". I have also tried "CUSTOMER_ID NOT LIKE '4570%'" but * and % both work according to MS Docs.

The resulting data is filtered correctly to exclude exact matches for Customer Id's 1604002 and 3708001, but not correct for the NOT LIKE condition.

Does my filter need to be structured different?

0

There are 0 best solutions below