Skip to main content
WolfShade
Legend
June 5, 2009
Question

Converting query to SP; ListQualify is breaking string for SQL

  • June 5, 2009
  • 2 replies
  • 817 views

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,

^_^

    This topic has been closed for replies.

    2 replies

    BKBK
    Community Expert
    Community Expert
    June 6, 2009

    Could you show us that part of the code?

    Inspiring
    June 5, 2009

    try quoting the quotes.

    WolfShade
    WolfShadeAuthor
    Legend
    June 5, 2009

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

    Thanks,

    ^_^

    Inspiring
    June 5, 2009

    The former