The syntax calls for the variable name to be enclosed in single quotation marks. However, if the data in the variable contains single quotations, it screws up the query and produces an error.

Any workarounds, or do I have to parse things out to wrap a single quotation mark within two single quotation marks?

DP