Converting query to SP; ListQualify is breaking string for SQL

[WolfShade]

Hello, all.

I'm attempting to convert a number of queries into SPs; for the most part, it's going smoothly.

However, there is one query (quite large) that I am having problems converting to SP because the query is using ListQualify to insert apostrophes around each list element, and it's breaking the string being sent.

How can I keep the apostrophes without breaking the SQL string?

Thanks,

^_^

[Dan_Bracuk]

try quoting the quotes.

[WolfShade]

Just escape the apostrophe with another apostrophe?  OR, do you mean surround the apostrophe with quotes? (" ' ")

Thanks,

^_^

[Dan_Bracuk]

The former

[BKBK]

Could you show us that part of the code?