SQL Server Performance

Multivalue parameter where the values could have comma

Discussion in 'SQL Server 2005 Reporting Services' started by vmon, Nov 28, 2007.

  1. vmon New Member

    When my passed parameter is parsed and used in a procedure the parsing is not working because the values may have comma's and the parsing is not happening correctly to select a column. I have county and State in a single column seperated by a comma. When this is parsed I am getting values that are not in the column being selected. Is there a way to handle this?
    thanks.
    vmon
  2. anandchatterjee New Member

    Could you please provide the details more elaborately!! Your data itself containing the comma? Please reply with same sample data or example..
  3. Madhivanan Moderator

    Can you post the code you used?
    Also post some sample and expected data

Share This Page