>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
You have to make the single quote in the variable have 2 singles - e.g.
.. WHERE field = 'Bob''s Big Boy'...
Insanity: Doing the same thing over and over and expecting different results.