use %%: sprintf(qryStr, "SELECT * from SpecTable where part_no like '%%f9%' and spectype ='%s'", mode);

[ktyson]

I am trying create an sql query string using sprintf but my query contains %f. How do I escape %f?

sprintf(qryStr, "SELECT * from SpecTable where part_no like '%f9%' and spectype ='%s'", mode);

[Wolfgang]

use %%:

sprintf(qryStr, "SELECT * from SpecTable where part_no like '%%f9%' and spectype ='%s'", mode);

[menchar]

"%%"

[menchar]

We doubled 😉

[Wolfgang]

matching the double %

[menchar]

Pun intended