> "SELECT ... FROM ... WHERE col LIKE '%%'+?1+'%%';" In SQL the string concatenation operator is `||`, so: `SELECT ... FROM WHERE col LIKE '%' || ?1 || '%'` Whether or not the % signs need to be doubled depends on the exact API you're passing the string to, but `sqlite3_prepare_v2()` does not expand/process percent signs so do not double them.