Lucky9 (10/6/2013)

---

i have a stored procedure where the customername parameter is a comma separated

i am calling that parameter in the dynamic where clause the problem is am getting the error unclosed single quotation,reason am getting that error because

values of customer names column are as follow

Will o'smith

Roa's

so the customer name parameter is comma separated and used in the where clause