Loading

Multiple employee code in single variable with single quote

krunal pande

6y663

Hi team, How to store multiple employee code in single variable with separated by commas and each employee code in single quote in SQL server. Kindly suggest a way how to do it Thank you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jefferson S. Motta6y ago
try where [,...] is the others columns that you might have:
SELECT '''' + CAST(code1 AS nvarchar)+','+CAST(code2 AS nvarchar) [,...] + '''';
RESULT: '1,2'
Rajanikant Hawaldar6y ago
If your getting employeecode for example like emp1,emp2,.. Bind it array string or list by spliting comma or single quote or double quote. employeeCodeList = datareader["employeecode"].Split(", "); https://www.c-sharpcorner.com/UploadFile/mahesh/split-string-in-C-Sharp/