Special Characters and filtering operators

in order to "ignore" special characters, we normally place "@@" to do that

However, when you want to do a range of values with special characters, using "@@" does not work.

Here is the explaination:
Quoted from Sarah Kloser
The reason the "@@" doesn't help is because the "@@" makes the filter overlook all special characters - even your ".." and "*". An easy way to think about this is that the "@@" puts single tics around the filter so that it will be accepted as a value. So, if you have a value like (TEST)CUST, it will pass to the DB as '(TEST)CUST'. If you put in a range of values, it puts the single tics around the entire expression/filter: '(TEST)CUST..(TEST)CUST#3'.

So here is how you can work around in another manner:

Filtering Example for special characters.xlsx