I am storing a SQL query in my strings.xml file and I want to use String. Format to build the final string in code. The SELECT statement uses alike, something like this:
SELECT Field1, Field2 FROM mytable WHERE Field1 LIKE '%something%'
In order to format that I replace 'something' with %1$s so it becomes:
SELECT Field1, Field2 FROM mytable WHERE Field1 LIKE \'%%1$s%\'
I escape the single quotes with the backslash. However, I am not able to escape the % sign.
How can I include a like statement in my strings.xml file?