How to bind an input variable in a BigQuery WHERE LIKE clause

Hello!

You can try LIKE {{'%' + inputModal.value + '%'}} in your query.

You can also write your own statements in a javascript query and use the output to set a parameter declaration value and then just EXEC(thatStatement) Example EXEC

2 Likes