I throw my SQL queries that use a variable inside a Concat() function.
The sql text will be inside single quotes.
The variable with no quotes.
You may need to do triple single quotes if you need the variable to resolve inside single quote.
I can throw up an imagine a littler later when I’m on my desktop.