SQL INSERT with an b in data

I cannot insert a variable with an ’ in the data.
Is there anyway to specify the variable name in the SQL insert other than ‘%Variable%’

Can you include your insertion SQL here ?