I am trying to search for text that actually contains a % character in TSQL code.
For example, I have a product named 'ProductName' and SQL code that looks for it by this query:
WHERE product LIKE 'ProductN%'
I'd like Sql Search to limit the results by including the %
Sql Search text: 'ProductN%'
Is it possible to escape the % so sql search matches the % character?