How to escape "%" when doing a LIKE query?

When using LIKE, the wildcard character is “%”, but what if the field might contains “%” characters? Is there a way to escape this in the query, so the parser knows the difference between the actual “%” character and the wildcard “%” character?

Hi, you can try to use containsText instead of LIKE as:

SELECT FROM V WHERE Name containsText “%”