Escape wildcards in aggregate filter expression

Escape wildcards in aggregate filter expression

  

Is it possible to escape wildcard characters in the filter expression?

In MS SQL we have:

LIKE <pattern> ESCAPE <escape character>

For example:

LIKE '%\_%' ESCAPE '\'

will match any string with an underscore.


Solution

Hi Stanley,

Currently Aggregates don't provide built-in support for escaping LIKE special characters.

If you're targeting MS SQL Server, however, an alternative way of escaping either the % or the _ without using special syntax, is to enclose them in square brackets [ ]. For your example, it would be written LIKE "%[_]%".

Cheers,

Paulo Ferreira

Solution

Thanks Paulo. It works.