How to search for % in a string in Cognos Report Studio

If you need to search in a report for % it will not work. The % character is reserved in SQL.

The solution is to use \% (Backslash Percentage)