How can I map a variable along with the "LIKE" and "%" statement? I would like to match "text%"
(note the position of the percent sign)

The SQL should look like this:
SELECT * FROM WHERE LIKE ?%

I tried various combinations, which all failed:
?% and ? . '%' and '?%'