Exclude Text from BAQ

Kinetic ERP
1

I am trying to exclude a component of text from a free-text field within a BAQ. The text field in question has multiple variations, all including the address # “1505”. If I omit the 1505, I omit all of the variations. Thx in advance!

2

Post Malone What GIF by First We Feast

Are you just wanting to remove “1505” from the text, or exclude the row?

3

I want to remove rows that have “1505” in the text field.

4

in the criteria of the table, that’s as simple as

YourField <> LIKE '%1505%'

2 Likes
5

Bingo, thank you! I tried this permutation of NOT, <>, 1505. What threw me were the % as wild card characters.

1 Like
6

Keep in mind, depending on how many rows etc, this could be a dog. Might have to improve your query in other ways if so.