Escape wildcard %

[Florian Haase]

Hi,

Is it possible in the _like queries to escape the % - character for differencing between text or search-character?

When I for example have a text:

_eq: "My text contains a % character"

and if I now want to find all rows which contains exact this text, I have an issue:

_like: "%My text contains a % character%"

would also hit a row with the content:

"My text contains a # character"

the first and the last character are meant as wildcard search characters but the one in the middle as a text.

Its only a question and so far only a theoretical issue, but if there is a possibility to escape the character in the middle it would be great to know...

Florian

[Marius Bancila]

T-SQL allows you to escape these wildcards (https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver1...) but this is not a feature that we are currently supported. Therefore, unfortunately, you cannot do this.

[Florian Haase]

Ok,

That would also be a very rare scenario. But good to know.

Thank you