Hello, all.

I'm trying to convert queries that someone else built into Stored Procedures, and for the most part it's going smoothly. However, there is one query (pretty large and detailed) that is using some CF functions to format part of it, and I'm getting errors sending the data to the SP.

Two of the lines of the query are using CF's "ListQualify" function to put apostrophes around each list element, which (of course) breaks the string for SQL.

Any suggestions on how to preserve the string without removing the apostrophes?