Forum Discussion

Copper Contributor

Sep 13, 2022

How to pass multiple values into single string in Store

Hi All, I am passing a list of string into my stored procedure as a single value For eg: my procedure name is fetch_value It has single parameter called product. Alter procedure fetch _...

olafhelper

Bronze Contributor

Sep 14, 2022

Dhakshina25 , and how do you prefered to get it solve?

One way is to replace the comma with an other character, like the semicolon:

Set @product  = substring ((
    Select distinct ','+ REPLACE(product, ',', ';') 
    from main_table) T1 
    Order by 1
    For xml path ('')),2,2000);

Kalai_harini

Copper Contributor

Sep 16, 2022

Thanks for your valuable time
I exactly need(,) in the middle because my database value has comma in it, if I replace with semicolon it will not give any results