Need help filtering with special characters

costas

Hi all,

If i use some special characters in a filter all are ok. The problem is when i try to set a range with special characters that i need some help.

If i put the filter PO?11* in a field is ok but if i try to put this PO?11*..PO?12* i dont get anything back.

Is there any other way to filter a table using special characters?

kine

Filter PO?11*..PO?12* is too complex. Imagine case when You have this:

PO11190
PO11290
PO12620
PO21180
PO21270
PO21350
PO31150

If you want to select the range, you need to have fixed bounds. Because if you enter your filter, what will be the min and max value? Where the NAV can start and where is end? You can do something like:

PO11100..PO11199|PO21100..PO21199|etc.

Imagine that you are NAV and someone want you to select all values for this filter and you have just simply tools to select the values (you do not know "what" you as user wants to select... :-) it is hard to forget this, I know...). At first, you need to find minimum value and maximum value, which one it will be?