All customers EXCEPT..

yuppicide

Is there a way to filter customers to not include any with a + in their name?

I've tried something like <>*+* or <>*"+"* with no luck.

Savatage

Do they all have a + because they have something else in common?

Like a certain type of customer or something. Or was it a lasy thing, like someone not wanting to enter "and"?

Do the + all occur at the same place? does it start with a + or is it the 4th character, for example?

Your on Native DB right & No Dev License so I would think of a new field or new way if you need to "Mark" these customers in some way.

fverkel

Mark all records (Ctrl+A, Ctrl+F1).
Filter using *+*, then unmark these records (Ctrl+A, Ctrl+F1).
Remove the filter, then use Marked only.

You can use this method in C/AL-code.
On large tables this could cause performance problems.

yuppicide

That worked great. Although I think in the second instruction you meant CTRL+F1 first then CTRL+A. Thanks!