My Products
Help
Florian Haase
PARTNER

Escape wildcard %

by 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

2 REPLIES 2

by 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
PARTNER

by Florian Haase

Ok,

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

 

Thank you