Hi all,
I have One SP which accept the parameter @countrycode.
the input data is like this 'IN,UK,AS,WS'
now in sp there is query like
SELECT * FROM country_master WHERE C_Code IN (@countrycode)
now i want when it executed it must be like this
SELECT * FROM country_master WHERE C_Code IN ('IN','UK','AS','WS')
For that i have replaced "," char with " ',' " . but it then IN codition taking 'IN','UK','AS','WS' as a whole value . it did not consider IN , UK , AS, WS as a separate value
i don't want to use SP_Execute functionality.